Forum Discussion
Solved
DAX Dynamic Background Color Format for New Card Visual
I'm trying to create dynamic measure that changes the color of the card background depending on which measure is being evaluated in the new card visual. I have 6 measures/cards in this visual, so I w...
Hi idkwhatimdoing ,
I'm afraid a single multi-row card cannot be set with multiple colors at the same time. I would suggest using multiple card visuals instead, each with its own background color.
Best Regards,
Bof
Pragati11 , Thank you for your response... let me try to clarify:
This is the new card visual with multiple measures.
However, the background color of each card has been formatted by selecting a color for each measure, like so:
I want to be able to use one measure to format the background color of each corresponding measure. This is what I have, but all the cards are displaying as the same color: #6A040F.
Measure Color =
SWITCH(
SELECTEDMEASURE(),
[OB Empl FTE],"#0074D8",
[Total Apprv FTE], "#6C757D",
[Supv Position Count], "#003D72",
[Active Posn Count],"#001845",
[OB Empl Count],"#00223F",
[Total Vacant Posns],"#FFBA08",
"#6A040F"
)