Formatting specific cells in a measure

[deepak_dc]

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!

[Anonymous]

You're looking for "Conditional Formatting".

For more information, go here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/

[deepak_dc]

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]

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. 

Regards

[deepak_dc]

Thank you for your reply @v-ljerr-msft

I have posted this idea in powerBI idea forum 

Thanks,