Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How to show the detailed information, when the user click on a bar it should be hide and label should be show in detailed infromation. Example I have bar chart that is showing the sales category of information. But I need to show when user click on particular bar, that it needs to show the product Information. EX. Most frequently Sales places, and How much category etc...
Solved! Go to Solution.
Create a measure for each value that you want to display. Add all of these measures to a multi-row card visualization.
In this scenario, it think it's better to include those detail information fields into a Table visual. You may create some measures for product level. For example, if you want to show the max sales and place, you can create a rank measure or column, then add a visual level filter in that table.
Rank Column = RANKX(ALL(Table1[Place]),CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Product],Table1[Place])),,DESC,Skip)
Rank Measure = RANKX(ALLSELECTED(Table1[Place]),CALCULATE(SUM(Table1[Sales])))
Regards,
Create a card or multi-row card visualization such that when the user clicks the bar the detailed information is displayed. I have an example of this in my Ohio Schools PBIX file in the Data Story Gallery.
Measure = IF(HASONEVALUE(Table[Column]),VALUES(Table[Column]),"")
Thank you @Greg_Deckler. It is working file with single value return, But I need to show the multiple values on multi card list. How to write the measure for this
In this scenario, it think it's better to include those detail information fields into a Table visual. You may create some measures for product level. For example, if you want to show the max sales and place, you can create a rank measure or column, then add a visual level filter in that table.
Rank Column = RANKX(ALL(Table1[Place]),CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Product],Table1[Place])),,DESC,Skip)
Rank Measure = RANKX(ALLSELECTED(Table1[Place]),CALCULATE(SUM(Table1[Sales])))
Regards,
Create a measure for each value that you want to display. Add all of these measures to a multi-row card visualization.
No problem, sorry its a bit brute force but it does work!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |