cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ashwani_pal Regular Visitor
Regular Visitor

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

Accepted Solutions
ashwani_pal Regular Visitor
Regular Visitor

Re: Showcasing KPI in Matrix Cell

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

7 REPLIES 7
v-jiascu-msft Super Contributor
Super Contributor

Re: Showcasing KPI in Matrix Cell

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.
ashwani_pal Regular Visitor
Regular Visitor

Re: Showcasing KPI in Matrix Cell

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

 

v-jiascu-msft Super Contributor
Super Contributor

Re: Showcasing KPI in Matrix Cell

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.
ashwani_pal Regular Visitor
Regular Visitor

Re: Showcasing KPI in Matrix Cell

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

 

 

 

Regards

Ashwani

v-jiascu-msft Super Contributor
Super Contributor

Re: Showcasing KPI in Matrix Cell

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.
v-jiascu-msft Super Contributor
Super Contributor

Re: Showcasing KPI in Matrix Cell

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.
ashwani_pal Regular Visitor
Regular Visitor

Re: Showcasing KPI in Matrix Cell

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 803 guests
Please welcome our newest community members: