Multiple index display in matrix

[Anonymous]

Hi all,

I ran into a senario where I want to insert several kpi Index into matrix which drills down by organizaion vertically and Variable column horizontally.

However it seems that PBI matrix doesnt allow users to input mutiple index for each variable.

the table belows shows the ideal output, having the index able to show colors or icon or marks according to KPI score.

--i have already built up the table without KPI index.--

Can anyone help me with this?
Really Really Appriciate your help. thanks a lot!

Current　 ↓↓

Ideal　↓↓

[v-easonf-msft]

Hi , @Anonymous 

Based on the information you currently provide, I think you may need to convert your original table into such a data model before creating the matrix visual.

If possible, please share your sample data for further testing.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt that is possible unless you create months as measures.

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc