Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to format the fields

Hi All

I created a report using multi card , which has 3 values  (start, inprogress ,end - as titles ) and have values 22 27 29 , i am not talking about conditional formatting , but i want to have the numbers color coded ( for example 22 balck, 27 red and 29 is green).

Thanks

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    We cannot achieve that by multi card visual, We can work that out by table visual. Here I create a measuare and use conditional formatting based on the measure as below.

     

    Measure =
SWITCH (
    TRUE (),
    SUM ( Table1[value] ) = 22, "#b20000",
    SUM ( Table1[value] ) = 25, "#ffc04c",
    SUM ( Table1[value] ) = 27, "#a500ff",
    "#198c19"
)

     

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks how about i do conditional formatting like column value >=0 black, column B >=0 Red......

      how and where can i do the conditional formatting?

      Thanks

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi Anonymous ,

         

        We cannot achieve that by multi card visual, We can work that out by table visual. Here I create a measuare and use conditional formatting based on the measure as below.

         

        Measure =
SWITCH (
    TRUE (),
    SUM ( Table1[value] ) = 22, "#b20000",
    SUM ( Table1[value] ) = 25, "#ffc04c",
    SUM ( Table1[value] ) = 27, "#a500ff",
    "#198c19"
)

         

         

        For more details, please check the pbix as attached.

         

        Regards,

        Frank