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.
On my report I have a world map, a time slicer for 10 year period, and a pie chart.
I want to see the pie chart for a country in a certain year, but I can only either select a country and see the entire 10-year average on my pie chart or select a certain year and see the world average.
Is there a way to use both time slicer and the world map as interaction filters for the piechart? I know I can add a slicer containing all the countries but it will be much simpler to be able to select country from the map.
Thanks in advance!
Hi @elsiered,
In Power BI Desktop, we are able to set interactions between each visual use Edit Interactions feature. See:
When we check one year in timeslicer visual and click on one cycle in the map visual, the pie chart is filtered by the year check in timeslicer and by the region checked in map. But please note the value displays in the pie chart is equal to the checked cycle's value in the map, not total of checked region's values.
so in your scenario, if you want to get the total values for checked region, you need to add a slicer with region field, then check one year in timeslicer and region in the slicer to get total values.
Reference:
Visualization interactions in a Power BI report
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Thank you for the explanation. However I'm afraid I wasn't clear enough. I'd like to select a location and a time range at the same time. In your example, I'm unable to select CA first, and then select 2010-2012 to see the breakdown of the data over that time range because once I click CA, the timeline slicer jumps back to default (covering all the years visible on the slicer) or when I click the time range on the slicer, the map jumps back to showing all the states in darker color.
Thanks for your help!
Hi @elsiered,
In your scenario, please click the date range in TimeLine slicer then click the circle in the map, you can see the value of clicked circle is the same as the value in Pie chart, though the TimeLine range is revert to cover all dates. Please check it in attached .PBIX file.
Best Regards,
Qiuyun Yu
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |