Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I want to apply condintional formating if if Aug is greater than july red others wise green !
Check below video for better understanding
https://www.youtube.com/watch?v=K-uhWhl9Grs
https://www.youtube.com/watch?v=wTRrskQzAHk&t=818s
I hope i answered your question!
You cannot apply the coloring to August only. However, you can create a measure that is MoM % using quick measures. Then, when you apply your conditional formatting to say if one month is greater than the one before it, you would color anything greater than 0 is red and less than 0 is green. It will apply to all months in the visual.
Here is an example I have:
Proud to be a Super User! | |
Write the Dax here I just want if Aug is greater than Jul its should be red otherwise it should be green
| User | Count |
|---|---|
| 50 | |
| 37 | |
| 31 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 135 | |
| 102 | |
| 60 | |
| 36 | |
| 35 |