Forum Discussion

deepak_dc's avatar
deepak_dc
Regular Visitor
9 years ago

Formatting specific cells in a measure

Hi all,

 

Hope you all doing great!
I want to customise my report. In order to do that, I want to specifically format specific cells which contains value 0 or the value which contains highest value in a measure.

 

I am attaching a snap below. 

 

In this example, I want to format 'new' measure in such a way that it becomes easy to distinguish highest and lowest value in a measure. 

Please help. Let me know if this question is not clear or incomplete. 

 

Looking forward

Thanks!

Need Help

4 Replies

    • deepak_dc's avatar
      deepak_dc
      Regular Visitor
      9 years ago

      Thank you for your reply.

      I'm looking to format only specific cells like only the cells which contains Highest and Lowest value in a measure.

      Could you suggest me the solution for the same

       

      Thanks,

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

        Hi deepak_dc,

        I'm looking to format only specific cells like only the cells which contains Highest and Lowest value in a measure.

        Could you suggest me the solution for the same

        Currently, the condition formatting option will format all cells in the column based on their values. So I don't think there is an alternative way to format only some specific cells(i.e. Highest and Lowest value) currently. I would suggest you add it as an idea on Power BI Ideas forum to improve Power BI on this feature. :smileyhappy:

         

        Regards