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

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        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