Showcasing KPI in Matrix Cell

[ashwani_pal]

Hi, 

I need to Show KPI as colored shapes (color changing with KPI value) as shown hereby.

How can i achieve this?

Thanks 

Ashwani 

[v-jiascu-msft]

Hi @ashwani_pal,

Did you solve the issue?

Best Regards,

Dale

[ashwani_pal · Accepted solution]

Hi

Yes. Its resolved. We provided only UNICHAR for round and then done conditional formatiing on that which provided reuired color based on value. 

Regards

Ashwani

[v-jiascu-msft]

Hi Ashwani,

Please try a measure like below.

Measure =
IF ( MIN ( Table7[Column1] ) < 0.8, UNICHAR ( 128308 ), UNICHAR ( 128309 ) )

Best Regards,

Dale

[ashwani_pal]

Hi Dale,

Thanks for solution. I get the desired shape but its black in color as shown.i used the same UNICHAR code as you.  How can i change color to desired one.

Regards

Ashwani

[v-jiascu-msft]

Hi Ashwani,

Weird, do you really use the same code with mine? Can you share the pbix? You can delete other parts.

Best Regards,

Dale

[ashwani_pal]

Yes, I did use same UNICHAR code. I am hereby attaching a screenshot.

Regards

Ashwani

[v-jiascu-msft]

Hi @ashwani_pal,

Quite weird. Can you share the file? Only the necessary parts are needed.

1. Please upgrade the Desktop to the latest version.

2. What's the version of your OS?

3. What does it look like after publishing to the Service?

Best Regards,

Dale