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.
Hello,
I want the values under the months to be green if they are lower R21, Blue if they are between R21 and B22, and red if they are higher than B22.
like this:
Thank you,
Solved! Go to Solution.
Allright, your "data" isn't really data. It's already a report. You should consider transforming your data to a more appropriate format.
That being said, here's how to do it with your current format.
Create a measure than checks if its lower than R21 or higher than B22 as below
Use the measure to format the specific coloum. Note that you need to do this to every column. jan, feb, mar, etc.
Allright, your "data" isn't really data. It's already a report. You should consider transforming your data to a more appropriate format.
That being said, here's how to do it with your current format.
Create a measure than checks if its lower than R21 or higher than B22 as below
Use the measure to format the specific coloum. Note that you need to do this to every column. jan, feb, mar, etc.
Measu like as below:
when i done second part it gives error
What is wrong?
It seems you have more than one table, as you are summing on sheet1 and table one
I'm gonna try and ask this again:
How is your data structured?
SUM(Sheet1[January]) < SUM('Table 1 (KPI2022)'[R21])
How is you data loaded into Power Bi? I see you are referencing Sheet1 and Tabel 1 (KPI2022)
Do you have more than one table? Can you send a screenshot of your datamodel?
Yes my fault you are totally right. Sorry for this. It's fixed now, thank you very much.
But now I realized that in some values, I need to color the opposite.
We did this:
I want the values under the months to be green if they are lower R21, Blue if they are between R21 and B22, and red if they are higher than B22.
But on some of my values, I want to colorize the opposite. I will try to explain in more detail.
We said that if the value is greater than R21, the background should be green. Yes this is true for some fields eg Oee, rft micro etc.
But this is not true for energy, waste, water. It has to be red for them. For this reason, can I differentiate it by specifying Area?
Sure, you can add an additional condition
What type of visual is this? How is you data structured?
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 |
---|---|
55 | |
54 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |