Forum Discussion
Create KPI table with matrix table, with category and sub-category
Hi Angko2528 ,
In matrix only values can be conditionally formatted.
If you wish to have this feature implemented, you can post your idea in ideas forum.
https://ideas.powerbi.com/forums/265200 .
Hope this helps!
Community SupportHi Angko2528 ,
1.You can create a calculated column using switch function where it would assign category to each KPI.
2.Then use this new column (category) as rows in matrix visual
3.Then click on the visual and go to format pane where you switch the style to "Tabular"
Below screeenshot for reference-
For calculated column-
More about switch function
Additional links which might help
https://community.fabric.microsoft.com/t5/Desktop/How-to-add-multiple-rows-side-by-side-in-matrix-visual/m-p/4276479
I hope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
