Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Hiding numbers in Conditional Formatin

Hi,

 

How can I hide the numbers in Conditional formatting, when used in Power BI Desktop within a Matrix visualization?

 

I use a few rules with background colours and would like to show colours only (similar to the option in Excel).

 

Thanks,

Tamir

  • Hi Anonymous,

     

    By my tests, it seems that there is no option for us to hide the numbers in matrix in Power BI currently.

     

    You could set the same rlue for font color scales and background color scales. Then you will get the output like below.

     

     

    Hope this can help you!

     

    Best Regards,

    Cherry

6 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Anonymous,

     

    By my tests, it seems that there is no option for us to hide the numbers in matrix in Power BI currently.

     

    You could set the same rlue for font color scales and background color scales. Then you will get the output like below.

     

     

    Hope this can help you!

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you v-piga-msft

       

      That will do the trick :-)

       

      Regards,

      Tamir

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar

        Hi Anonymous,

         

        It ‘s glad that we can help you. That 's my pleasure.:smileywink:

         

        Best Regards,

        Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable

    there is option to select Icons layout in the Icons advanced controls menu. 

    Set it to "Icons only" and this will remove the values and show icons only in the matrix table.!

    • lbruns's avatar
      lbruns
      New Member

      Hi there! I've found that when you select "Icons only," the value still displays when you hover over the icon, even with Tooltips turned off. Do you know if there's a way to make it so that the value that you used for the icon's conditonal formatting never displays?