cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pitchaimuthu
Helper II
Helper II

how to show the detailed information on label, when user click on particular bar?

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...

2 ACCEPTED SOLUTIONS

Create a measure for each value that you want to display. Add all of these measures to a multi-row card visualization.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

@Pitchaimuthu

 

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])))

99.PNG

 

 

Regards,

View solution in original post

8 REPLIES 8
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Thank you @Greg_Deckler. Could you provide, how to write the measure for that?

Measure = IF(HASONEVALUE(Table[Column]),VALUES(Table[Column]),"")

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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

@Pitchaimuthu

 

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])))

99.PNG

 

 

Regards,

View solution in original post

Create a measure for each value that you want to display. Add all of these measures to a multi-row card visualization.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Thank you @Greg_Deckler

No problem, sorry its a bit brute force but it does work!


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors