Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Monthly Percent in a Table and conditional formating

Hi all,

 

I've got an issue:

 

I'm using a Table and want to get the numbers in green an %-sign behind those values. How is this possible? 

The green numbers are a 'messurement' created via DAX, I've allready tried to add '& "%" ' behind the DAX but no result.

 

Second question:

I want to get all the values below 80% in red, or that the field is in red.

Tried the conditional formatting but all values are in green.

 

Many thanks!

  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Anonymous,

    Until now, we can't set the specific color for different colors. Please review this feature request and vote it. Power BI only support gradient color in conditional format, please try the following solution, and check if it works fine.

    1. Right click your column wanted to add color->conditional format->font color scales as follows.



    2. Type the 0.80 as minimum and 0.81 as maximum, you will the close result.


    Best Regards,
    Angelia

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Ok I solved my first question about the %-sign.

     

    But still no sollution found for my value or field conditional formating

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Ok I solved my first question about the %-sign.

     

    But still no sollution found for my value or field conditional formating

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi Anonymous,

      Until now, we can't set the specific color for different colors. Please review this feature request and vote it. Power BI only support gradient color in conditional format, please try the following solution, and check if it works fine.

      1. Right click your column wanted to add color->conditional format->font color scales as follows.



      2. Type the 0.80 as minimum and 0.81 as maximum, you will the close result.


      Best Regards,
      Angelia

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Thanks it works great!