cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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

View solution in original post

7 REPLIES 7
Microsoft v-jiascu-msft
Microsoft

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

 

Microsoft v-jiascu-msft
Microsoft

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

Microsoft v-jiascu-msft
Microsoft

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

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.
Highlighted
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

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors