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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Garbo62
Helper III
Helper III

Conditional Formatting missing from most graphs

I'm moving my reports from Excel to Power BI.

Conditional Formatting missing from most graphs I have created in my Power BI reports, so I have different colous all over the place and different when i update the data.

Is there an alternative way to control the colour of graphs, I can put the #HEX number in each table if necessary.

6 REPLIES 6
Garbo62
Helper III
Helper III

Hi I tried to colour in all graphs based on the colours defined in the table "Lookup Data Colour" here is the link to the pbix file , happy to do a call if necessary

Adept Buildings SUS Demo.pbix

 

Alex87
Super User
Super User

please provide sample data, focus on one or two visuals and show the end result you want to achieve based on that data 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!




Garbo62
Helper III
Helper III

Hi in this screen shot only 2 graphs have the conditional format option.

Garbo62_0-1713812125291.png

 

Looking at one graph you see formatting is not a option and the colour option is disabled

Garbo62_2-1713812312037.png

If necessary i can build a sample model

 

 

I think I can see what is the problem:

- for the 100% stacked bar chart & stacked bar chart & clustered column chart you should choose something else than "Apply settings to all". You can choose the color you want for each legend category

- for the donut chart you can choose the colors of your choice for each slice

 

Alex87_0-1713814210672.png

Is this answering your query?




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!




Hi, but you still can't appy conditional formatiing, I have a table with all the results and #hex colour and I want to format as per the the following link Set Power BI Data Color All Visuals to Follow Same Color for the Same Data Point - YouTube

But is condition formatting of graphs is not allowed is the an alternaive way of having consistance colour accoss graphs. i.e. I want a depatment to have the same colour in each graph

NB I rerun this reports for multible clients each week and over 200 different variables

Garbo62_1-1713863745032.png

 

Alex87
Super User
Super User

you can conditionally format in Power Bi many graphs. Can you provide an use case you are working on where you encounter the problem, a sample data, en example of the expected output? We are missing the context and it is difficult to provide an answer to your problem.




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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