Forum Discussion
Power KPI Matrix using Year / Quarter as headers
Hi All
I have a question about the Power KPI Matrix visual. I can get the KPI and its values but was trying to find a way to add quaters/yearr as in the table below as headers. Let me know if you have any questions
Hi Anonymous
I think your table should look like as below.
Power BI doesn't support you to use column header directly. You need to transform column headers into one column by unpivot and then you can use them in your Matrix visual.
For reference: Unpivot Columns in Power BI
New table looks like as below.
Result:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous
I think your table should look like as below.
Power BI doesn't support you to use column header directly. You need to transform column headers into one column by unpivot and then you can use them in your Matrix visual.
For reference: Unpivot Columns in Power BI
New table looks like as below.
Result:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.