Forum Discussion

ashwani_pal's avatar
ashwani_pal
Helper I
8 years ago
Solved

Showcasing KPI in Matrix Cell

Hi,    I need to Show KPI as colored shapes (color changing with KPI value) as shown hereby.   How can i achieve this?     Thanks  Ashwani 
Need Help
  • ashwani_pal's avatar
    ashwani_pal
    8 years ago

    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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

  • ashwani_pal's avatar
    ashwani_pal
    Helper I
    8 years ago

    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's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      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's avatar
        ashwani_pal
        Helper I
        8 years ago

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

         

         

         

        Regards

        Ashwani