Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Using the dax below, I have created a conditional column where certain %'s turn specified colors if not meeting targets by a certain date. The dax works great but my issue is this... when I go to apply it on the visualization (matrix) it is coloring my individual lines (Level 1) the correct colors but the roll up (averages) of my object descriptions (Level 2) is summarization "First" color at random. How can I get it to apply the correct color to individual lines as well as the averaged lines that the individuals are being rolled up into. The ask is for all to be colored not just values or totals.
DAX used:
Average column I am having issues with: ex data set is the 3 values in the green box are individual lines and the 28% in the purple box is the average of the individual lines... the 28% should be orange based off what I am looking for. The individual lines are colored correct.
Is there something to change in the dax to fix it or some special secret I should know on how to get the roll up averages to color code the same way the individual lines color code.
All the thanks for anyone who can help solve my problem!!!
Olivia
Hi @omcknac ,
Thanks to @sevenhills for the reply, please allow me to provide another insight:
Please try changing the format style to field value and put the measure you created as a field.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do I need to change the DAX in order to avoid the summarization option being present?
Edit to reply: I changed the DAX to include MAX:
It didn't change the roll up average turning green instead of orange.
Hi @omcknac ,
Please put the color status directly into the visual object and check whether the result it returns is the result you want. If the result presented in the visual object is not the result you expect, please try to modify the expression and then put it into the condition in format. More details about conditional formatting can be found in the documentation: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn.
Also, if you are willing to provide a pbix file with sample data, I will be able to help you solve your problem better.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Quick check, what is the setting for your rules for background color in conditional formatting?
Is it like this?
Yes I have it set to values and totals, but because the summarization is there its just choosing the "first" color that appears in the line up.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |