Data Viewing Function in Visualization

[liuy70]

Hi! I am transferring from Tableau to Power Bi and have some questions regarding extracting data from visualizations. In Tableau, there is the function where when you click on the point/bar/line on the visualizations, you can view the underlying data in the filtered columanized format, like this 

I am wondering if we can achieve this in Power Bi. For now, I have only learned that the 'show as a table' which will only gives me the calculated (summary) table, not the original lists. See example . I am aware that I can achieve this by building a separate panel which displays the raw data with filters I want. But I am wondering can Power BI achieve the same thing as Tableau do? Click on the point/lin/bar in the plots and extract those groups of raw data. 

Thank you so much!

[Anonymous · Accepted solution]

Hi @liuy70 ,
Thanks to @_AAndrade  for the solution,
Based on your description, as mentioned, you can drill down to return the original list with filters after clicking on a single piece of data. Of course, you can also redirect to another page by using bookmarks. Or use a synchronized slicer to achieve something similar to the functionality in tableau. Here's some documentation you can refer to
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Enable the Sync Slicers feature in Power BI visuals - Power BI | Microsoft Learn
Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[_AAndrade]

Hi,

You can build a tooltip with this kind of information or use drill through option.
Take a look at this video: https://www.youtube.com/watch?v=BbplhqDCWOM