Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
DiffToFC1 = SUM(FactForecast1[Amount])-sum(FactActuals[Amount])
This works except the formatting pushes out into the future for months that have not occurred... for which I would never have actuals. I am uncertain how and where to indicate "current month" so conditional formatting can be applied correctly. It can be pulled or inferred from my source data but I don't know how to leverage it.
@roshak , you can create a color measure and use that in conditional formatting using field value option
example
DiffToFC1 = Switch(True() ,
eomonth(max(Date[Date]),0) = eomonth(today(),0) && SUM(FactForecast1[Amount])-sum(FactActuals[Amount])<0 , "red",
eomonth(max(Date[Date]),0) = eomonth(today(),0) && SUM(FactForecast1[Amount])-sum(FactActuals[Amount]) >0 , "Blue",
"Pink")
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
That approach works if I am able to use TODAY() as the comparator. However, my "current month" is a static value that exists in my data. Do you have a recommendation on how to store/reference that value?
That looks promising and I'll give it a try. However, my "current month" is a value from my data , not the actual date. I am struggling with how and where to store that info.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |