Multi KPI Color

[Purushothaman]

Hi Experts,

I have requirement in multi KPI  on the conditional colours for Dimension and measure . 

Below are the current Multi KPI and Expected Multi KPI.

I have also attached QVF.

Thank you!

[Anil_Babu_Samineni]

@Purushothaman Can you please share logic of Why Green (6), red (4), yellow (2) ...

[Purushothaman]

Hi @Anil_Babu_Samineni ,

Below is the dataset. Its of count of ID with Dimension of Status.

Status	ID
Red	AD1
Red	AD2
Green	AD3
Green	AD4
Red	AD5
Yellow	AD6
Yellow	AD7
Red	AD8
Green	AD9
Green	AD10
Green	AD11
Green	AD12

Thank you!

[Anil_Babu_Samineni]

@Purushothaman It means you want to arrange a color based on Status? 

[Purushothaman]

HI @Anil_Babu_Samineni ,

Yes you are right. 

Thank you!

[Rohan]

Hi @Purushothaman ,

You will have to apply CSS in the multi KPI to get your desired O/P. Or alternatively, You can show it in a Pivot Table & Colour by Dimension.

Regards,

Rohan.

[Purushothaman]

Hi @Rohan ,

Based on my requirement, could you able to suggest some code?

Thank you

[Anil_Babu_Samineni · Accepted solution]

Since that is limitation in Multi KPI, I would suggest to use pivot table and make it work. Attached the version with pivot table.