Show data corresponding to a chart in tabular form when clicked/hovered as a model view.

[vinkesh-serene]

Hello Everyone,

I am creating power Bi dataset/s with desktop and after publishing them to power BI online adding them to different dashboards.

Afterwards showing them inside another ASP.NET application using Power BI API.

At the moment showing two different reports on one view [Pie/bar chart in one section and tabular data in other section] which is a bit space consuming. Is it possible to only show the pie/bar chart on view and only show the tabular data when requested like when user click on the pie/bar chart?

What I am able to do:

What I am trying to get:

 

Any help much appreciated.

Thanks in advance

[Greg_Deckler]

Potentially, I would investigate bookmarks and tying an image to a bookmark as a toggle.

[vinkesh-serene]

Thanks for the suggestion.

Tried, though bookmark feature will only work on the report level and will not work as soon as we will add them reports on a dashboard. Though I was trying to get it working with the tiles somehow (Not able to get it working even if I tried adding a add an image and added a link to another bookmark or report - that image is not visible on the tile etc).

Any workaround you aware of where we can do something like this with the tiles on the dashboard.

Thanks

[v-huizhn-msft]

Hi @vinkesh-serene,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will get useful from here.

Thanks,
Angelia

[vinkesh-serene]

Hi @v-huizhn-msft

Sorry for that (Tried to get it working somehow for two days with no success, got annoyed and started working on something else ),

Whats needed is not possible at the moment I think, the issue is still in there as both the bookmarks feature and [Show data] will not be available as soon as I will embed them either on the dashboard and dashboards on third-party (I have another application where different dashboards needs to be visible for different roles) application using the [PowerBI.Api.V2]  (These features only available on dataset level).

Though bookmarks on the dashboard are already on Ideas board so expecting it to be available down the road. 

Thanks for your time and efforts.

[v-huizhn-msft · Accepted solution]

Hi @vinkesh-serene,

When you click more options(...) on the top-right of you visual->show data as follows, you will view all data shown in the visualization.



Best Regards,
Angelia