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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Retriever
Frequent Visitor

Keeping Filled Map Colors Consistent when filtering

Hi there! 

 

I'm hoping that you can help me with what may be an obvious solution, I just can't find how. I have a dataset of states (United States) and corresponding dates, and have created a dashboard that has a filled map for the United States and a bar graph counting by Month. I've changed the data colors for the map to a color scale, such that the earlier -> later dates are the minimum and maximum.

 

I currently have graph interactions on, such that clicking on a month filters the map to show only the states that relate to that month. But -- here's the problem. Clicking on a given month filters the map correctly and shows the related states, but then it redoes the color scale for the graph. For example, if I select May which is on the left side of the overall color scale, it redoes the color scale and treats late May as the right side of the scale. It changes the colors related to what's in the current filter.

 

Is there any way to keep the map colors consistent, but allow the bar graph to still filter the graph such that the related states still show? Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
2 REPLIES 2
v-xicai
Community Support
Community Support

Hi @Retriever ,

 

You may use "Edit interactions" feature to choose which visuals to be filtered by one special visual. See more details: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions.

edit interactions.png

 

 

 

 

 

 

 

 

For reference:

https://community.powerbi.com/t5/Desktop/Table-Filter-Interactions/m-p/669088#M321878

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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