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

[Pitchaimuthu]

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

[Greg_Deckler · Accepted solution]

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

[Greg_Deckler]

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.

[Pitchaimuthu]

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

[Greg_Deckler]

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

[Pitchaimuthu]

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

[v-sihou-msft · Accepted solution]

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

Regards,

[Greg_Deckler · Accepted solution]

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

[Pitchaimuthu]

Thank you @Greg_Deckler

[Greg_Deckler]

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