filter by each distinct value

[Anonymous]

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.

[v-danhe-msft]

Hi @Anonymous,

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

 

[GilbertQ]

Hi there

Could you not use the conditional formatting and click on the drop down and use Field Value

Here are details from the blog post, which explain exactly how to do this
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#conditionalFo...