Forum Discussion
filter by each distinct value
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(****[...
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
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/#conditionalFormatting
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/#conditionalFormatting