I'm usually quite good with Power BI, but weirdly stuck on this matrix, that I'm trying to create. I just can't seem to get the data in the right format to produce the below chart. Can anybody help?
I've used this format, and put KPIs on rows, Product and type on columns and KPIs on values, but doesn't work.
I also pivoted the data so that KPI 1,2 and 3 are attributes and the value the value. But the issue is with KPI 2 that is a decimal, while KPI 1 and 3 are percentages.
I'm usually quite good with Power BI, but weirdly stuck on this matrix, that I'm trying to create. I just can't seem to get the data in the right format to produce the below chart. Can anybody help?
I've used this format, and put KPIs on rows, Product and type on columns and KPIs on values, but doesn't work.
I also pivoted the data so that KPI 1,2 and 3 are attributes and the value the value. But the issue is with KPI 2 that is a decimal, while KPI 1 and 3 are percentages.
Share Improve this question edited Jan 30 at 15:18 davidebacci 30.3k4 gold badges18 silver badges47 bronze badges asked Jan 30 at 11:30 ninelondonninelondon 14910 bronze badges 1- Was your problem solved? – davidebacci Commented Feb 10 at 18:29
1 Answer
Reset to default 0You have the correct approach with this:
I also pivoted the data so that KPI 1,2 and 3 are attributes and the value the value. But the issue is with KPI 2 that is a decimal, while KPI 1 and 3 are percentages.
You just need to ensure you store the values as numbers only and then use a dynamic format string for displaying the percentage sign where appropriate.
https://www.sqlbi/articles/introducing-dynamic-format-strings-for-dax-measures/