Cell Formatting

[Anonymous]

I am trying to introduce colour to a cell, to add value to visualization

In Excel it looks like (below) the the Colour column displaying the required Hex code required

How can i show in Power BI i.e. Format a Cell, or Row, or Text, or even add a Shape with colour

Any thoughts / comments appreciated 

[selimovd]

Hey @Anonymous ,

you can format the cell with conditional formatting:

As far as I know you can do the formatting based on a field/measure, but you still have to define the colors for each result:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[amitchandak · Accepted solution]

@Anonymous , in Conditional formatting use field value. Choose max of this colour

or create a measure Max(Table{colour]) and use that in matrix with field value column.

[Anonymous]

Thank you

I had to change one Hex value to get the correct colour but works like a dream

Question is there a way to hide the text (Hex code)?