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.
Friends,
I am working on a BI report where I have a treemap showing different systems on the first page. Based on the selection done on the treemap, I want the system slicer to show the same value. What i am trying to do is create the same slicer on the second page, and get the slicer to sync, so the detailed items (in the second page) can be filtered based on the treemap selection on the first page.
Based on some googling I found post that said that you can use the function SELECTEDVALUE. I am not sure how to use it in the treemap and the slicer.
Please give me some suggestions.
Thank you
Solved! Go to Solution.
@Anonymous , if you want drill value to pass, you need to use drill through. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
For slicer's Sync slicer can work: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages
@Anonymous , if you want drill value to pass, you need to use drill through. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
For slicer's Sync slicer can work: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages
Hello,
thank you for the tips. Drill through might be the only way for this.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |