Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to Conditionally format text in a Card in Power BI

  I have a Card in a power BI Dashboard that that displays roughly 6 unique text attributes depending on the input. How do I add a separate color to each attribute, for example if the card displays ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hate to bother you again but I tried the code you suggested and it pretty much worked however it displays "#ff0000" in red, and not the text like "Apple" in red.

 

What I have:

IF(SELECTEDVALUE(Colors[Color])="Apple","#ff0000",IF(SELECTEDVALUE(Colors[Color])="Watermelon","#55ff22","#ff7722"
evandrocunico's avatar
evandrocunico
Icon for Resolver III rankResolver III
7 years ago

Anonymous can you show data table, please?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    evandrocunico 

    I can't show the exact table due to confidentiality and I understand if you can't solve this because of that, but essentialy I have a table called food:

     

    Food

    • Meat- Beef, Chicken, Pork
    • Fruit- Apples, Oranges, Watermelon
    • Vegtables- Carrots, Broccili, Peas

    I only care about the Fruit attribute inside the food table 

  • evandrocunico's avatar
    evandrocunico
    Icon for Resolver III rankResolver III
    7 years ago

    Anonymous create a measure:

     

    sel_fruit = SELECTEDVALUE(Colors[Color])

    show measure by card and filter option...

    the result is Apple?

     

    ps. excellent channel about power bi https://www.youtube.com/watch?v=zHzSBNES6jE