Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |