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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

how to consistently color visual dimension values

I have a report with lots of visuals.  Most of these visuals will be broken down by field (dimension) [Mbr Mkt].  [Mbr Mkt] only has 6 values.  I want the color for each of these 6 values to be consistent across all visuals.  And, because there are so many visuals, it would be unreasonable for me to manually pick the 6 colors in each and every visual.  So, I created a report theme (accepting that the same theme will apply to visuals that don't use [Mbr Mkt]).  However, the colors I have set in the report theme are not always matching the desired mapping for [Mbr Mkt].  And, the colors seem to be randomly applied upon clearing my cache.  How can I solve this?

 

Here is my desired color mapping for [Mbr Mkt].  Unless I'm mistaken, Power BI assigns the color values alphabetically for a given dimension.  So, in my "mapping", I arrange [Mbr Mkt] alphabetically.

20200429 - 3.png

Here is my report theme json file.  As you can see, its order matches that of my mapping.  So, for example, if the visual uses [Mbr Mkt] as a dimension, 'EE' should appear as dark blue.

20200429 - 2.png

Here is an example of the report theme not applying as desired.  For example, notice that [Mbr Mkt] 'EE' should always be dark blue, and yet it appears as light blue in every visual.

20200429 - 1.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I have confirmed that my imported theme is present.  Creating a new theme via 'Customize theme' produces the same unexpected assignment of colors.  Clearing my cache also had no effect.  So, it seems that my only solution is to manually select the colors in each and every visual.

View solution in original post

3 REPLIES 3
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

It works well in my powerbi desktop . I didn't see any  error from your json file .It's so strange.

My test:

46.png

 

Maybe you can take a try of customize current theme.

 

43.png44.png

 

For more details ,please refer to this document and this demo.

 

Best Regards,
Community Support Team _ Eason

 

Anonymous
Not applicable

I have confirmed that my imported theme is present.  Creating a new theme via 'Customize theme' produces the same unexpected assignment of colors.  Clearing my cache also had no effect.  So, it seems that my only solution is to manually select the colors in each and every visual.

amitchandak
Super User
Super User

@Anonymous , Check if it there -https://docs.microsoft.com/en-us/power-bi/desktop-report-themes

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors