Forum Discussion

ashwani_pal's avatar
ashwani_pal
Icon for Helper I rankHelper 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

7 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper I rankHelper 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
        Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper I rankHelper I
      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