Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Masha
Frequent Visitor

Change visual based on slicer selection or measure value

Hello,

 

Here is what I have. Total Sales visual for Regions and drill down to Countries.

Masha_1-1651023017934.png

 

I would like to be able to show drill down of Countries if only one Region is selected.

I could have buttons for Regions and Countries linked to bookmarks and switch between the visuals, but I would like it to be dynamically displayed without user clicking and I don't think it's possible to "activate" button without clicking on it. 

 

So I tried Conditional formatting for bar and background colours, that's where I got to:

once one Region is selected - both bars and background are transparent and I could underlie another visual to display only Countries (and would need to work around on labelling etc)

Masha_2-1651023299574.png

 

The issue with this is that by selecting more than one Region the bar colour is now ignoring my measure and is automatically set up to white transparent. It looks like this:

Masha_3-1651023591181.png

Masha_4-1651023663003.png

Not good.

 

I tried the other way around, where Countries chart is on front and colours are transparent unless the Region equals one and visually it works, however drill down from Region chart becomes unavailable due to Layer order.

 

Has anyone came across it and possible work around?

 

 

This seems to be very similar request but, sadly, without currently available solution.

1 REPLY 1
v-zhangti
Community Support
Community Support

Hi, @Masha 

 

For your first question, link the region and country buttons to the bookmarks and switch between visual effects to display them dynamically, this can be done by trying to show the bookmarks as a slideshow and of course by tapping a start.

 

For details, please refer to the following document, hope it can help you.

https://docs.microsoft.com/power-bi/consumer/end-user-bookmarks#bookmarks-as-a-slide-show 

 

Best Regards,

Community Support Team _Charlotte

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.