CODEWITHSUNDEEP
excelpowerbipowerbi-desktoppower-bi-report-server
Magesh Maggi
Magesh Maggi

Reputation: 325

How to make relation with two sheets in excel or Power BI dashboard

Query : How to make relation between the table. In Power BI, I need to create a dashboard with two bar charts, the first of which will display reports by category. Second, the chart will display the product-based report. However, in order to create an interactive main chart, I need to connect two sheets. If you click the corresponding category in the main chart, the second chart will be based on the first chart's selected category. How to do that?

Main Report:

enter image description here

ProductWise Report:

enter image description here

enter image description here

Upvotes: 0

Views: 285

Answers (1)

Mr Robot
Mr Robot

Reputation: 322

Try to import data in separate sheet.

then just put categories to bar chart and remaining columns to other graph, Its automatically change.

Upvotes: 0

Related Questions