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.
Think my logic is off here but I always seem to struggle with things like this:
formatTest = IF( CALCULATE([%Cancelled],MONTH(****[ApplicationDate]) =MONTH(TODAY()),DISTINCT(****[Name])) < CALCULATE([% Cancelled],MONTH(****[ApplicationDate]) = MONTH(TODAY())-1,DISTINCT(****[Name])), "#008000", "#FFFFFF")
I want a cell in a matrix table to be coloured green if it is lower than the previous month's value, the current formula works in terms of the date, but it colours the entire column green as it is lower at an overall level, i want it to go down to the by each name level.
Table looks like:
Last month This month
Name
Name
Name
Name
Apologies if I am not explaining myself very well.
Hi @gp93,
Based on my test, I am afraid you could not use DAX formula to change the value's color, I suggest you use conditional formatting in tables:https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Regards,
Daniel He
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |