Forum Discussion

Prash546's avatar
Prash546
Icon for Helper I rankHelper I
6 years ago
Solved

Conditional formatting for values apparing through DAX logic and visualised in card visual.

I have created a DAX logic for getting values based on few logic to measure a metric, where my final result appears both in amounts and percentage and later I bring it this over to a card visual like 'Value above $XXX,XX & YY%' and it appears in black font, is there a way I can format in conditionally so that when it is negative I can make it appear in red and if it is positive it appears in green.

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    You can set Card visual->Format->Data Label->conditional formatting.

    I create a simple sample to show.

    Create a color measure to check:

    Color = IF(SUM('Table'[Value])>20,"#FF0000","#00FF00")

    Apply this measure to the Card visual:

    And it shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

     

2 Replies

  • VasTg's avatar
    VasTg
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Prash546 

     

    Select the card visual. Under the data label, on the right cornor, you would see three dots(eclipse icon). When you click, you would see conditional formatting.

     

     

    You could set the color based on Rules..

     

     

    If it helps, mark it as a solution

    Kudos are nice too

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    You can set Card visual->Format->Data Label->conditional formatting.

    I create a simple sample to show.

    Create a color measure to check:

    Color = IF(SUM('Table'[Value])>20,"#FF0000","#00FF00")

    Apply this measure to the Card visual:

    And it shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi