Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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,

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.