Forum Discussion
koiralasmn
2 years agoFrequent Visitor
Dynamic Color Changer for Cards
Hi,
I am currently working on a report where I have four KPIs
I want to dynamically make the Month to Month card on the top side of the visual change color.
This can be done using Dax to change the color using individual
Color for Variance = IF([MoM Revenue]>0, "#00bb29","#ff0000")
But is there any way where the DAX for colour automatically detects the fields used in the card so that the same DAX can be used over 4 cards?
I referred to fields as this
But is there any way where the DAX for colour automatically detects the fields used in the card so that the same DAX can be used over 4 cards?
I referred to fields as this
let me know if this is possible.
Thanks
1 Reply
- amitchandakSuper User
koiralasmn , if that is a card, then you can use the color measure in the Fx option of callout color, use the field value option