The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
65 | |
62 | |
60 | |
54 | |
30 |
User | Count |
---|---|
180 | |
88 | |
72 | |
48 | |
46 |