Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
76 | |
74 | |
56 | |
45 |
User | Count |
---|---|
117 | |
105 | |
77 | |
66 | |
64 |