Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashwani_pal
Helper I
Helper I

Showcasing KPI in Matrix Cell

Hi, 

 

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

KPI.JPG

 

How can i achieve this?

 

 

Thanks 

Ashwani 

1 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

View solution in original post

7 REPLIES 7
v-jiascu-msft
Employee
Employee

Hi @ashwani_pal,

 

Did you solve the issue?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Employee
Employee

Hi Ashwani,

 

Please try a measure like below.

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

Showcasing_KPI_in_Matrix_Cell

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

 

KPI.JPG

Regards

Ashwani

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

 

 

Regards

Ashwani

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.