powerbi - Power BI matrix - get data into correct format - Stack Overflow

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.

• powerbi
• dax
• visualization
• powerbi-desktop
• data-modeling

Share Follow edited Jan 30 at 15:18 davidebacci 30.6k44 gold badges1818 silver badges4747 bronze badges asked Jan 30 at 11:30 ninelondonninelondon 1491010 bronze badges 1

• Was your problem solved? – davidebacci Commented Feb 10 at 18:29

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You 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.com/articles/introducing-dynamic-format-strings-for-dax-measures/