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 t...
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

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

Hi Anonymous ,

 

Based on my test, it is not possible to meet your requirement currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Frank

  • 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

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

        Hi Anonymous ,

         

        Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

         

        Regards,
        Frank