Show data when selecting visuals

[jaytrice26]

Hello All,

I have a report that is showing data for a 3 month time period for a variety of items. I have a tooltip enabled that shows a high level count of the inventory levels. When they select each bar in the graph I want them to be able to see the break down of where the hardware was distributed. Is that something that I can do? 

[jaytrice26 · Accepted solution]

Thanks for all your help team. I ended up copying the bar graph and pasting it below and then changing it to a table. So now when a specific column in the bar graph is selected it will show the data behind it.

[jaytrice26]

@amitchandak thank you for that information as it was a good starting point and helped me get halfway there. I still need a way to show the data breakdown behind the visual. I would like to be able to do that without having to crowd up my visual with multiple graphs and tables and just have the table show when the user selects the data they want to review in depth.

[Anonymous]

Hi @jaytrice26 ,

Please check if the following links 

1. Show data as a table: Show the data that was used to create the Power BI visualization 

2. Create a tooltip page which include a table visual with the details just as suggested by amitchandak 

However, it seems that the tooltip page can't fulfill your requirement totally. Could you please provide the following info?

• The operations which you have done.
• What's your final expected result? Could you please provide more details(sample data, visual, screenshot etc.) on it?
• Your sample pbix file(exclude the sensitive info)

Best Regards

[amitchandak]

@jaytrice26 , You can use the tooltip page with the required visual

Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU

Power BI tooltip page: https://youtu.be/cN8AO3_vmlY?t=36240&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=1