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
Anonymous
Not applicable

Applying colour codes to a data set to apply to multiple graphs

As a newer user of Power BI i am have multiple charts showing data for a number sales products.  I want to apply a corporate colour for each product so that it is the same on every graph.  I know how to do this individually chart by chart but there must be a better way to do this, but cant work out how to do it.  I already have hex colour codes etc.

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can create a measure and apply it to the conditional formatting of the data color.

Measure = SWITCH(TRUE(),
                MAX('Table'[Product])="A","RED",
                MAX('Table'[Product])="B","LIME",
                MAX('Table'[Product])="C","YELLOW",
                MAX('Table'[Product])="D","GREEN",
                MAX('Table'[Product])="E","GREY",
                MAX('Table'[Product])="F","BLACK",
                MAX('Table'[Product])="G","PINK",
                "BLUE"
)

conditional formatting_2.PNGCapture2.PNG

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

View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can create a measure and apply it to the conditional formatting of the data color.

Measure = SWITCH(TRUE(),
                MAX('Table'[Product])="A","RED",
                MAX('Table'[Product])="B","LIME",
                MAX('Table'[Product])="C","YELLOW",
                MAX('Table'[Product])="D","GREEN",
                MAX('Table'[Product])="E","GREY",
                MAX('Table'[Product])="F","BLACK",
                MAX('Table'[Product])="G","PINK",
                "BLUE"
)

conditional formatting_2.PNGCapture2.PNG

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

Anonymous
Not applicable

Not sure this answers my question.  I am not trying to change the background and foreground but define what is in my data as "Products" with set colours in a graph and i have around 20 products.  So if a product is called Product "A" i always want the graph to show a set colour and if Product "B" another colour.  How do you define for each product the exact colour to want applied.  Thanks

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.