Forum Discussion

Julien_F's avatar
Julien_F
Icon for Helper I rankHelper I
6 years ago

KPI MATRIX visualization in a star schema model building Fact KPI table

Hello!   I was finihing several dashboards then yesterday I discovered that post : https://community.powerbi.com/t5/Custom-Visuals-Development/power-kpi-matrix/m-p/515378#M1351 where v-viig explain...
Need Help
Tutorial Requests
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Julien_F 

 

You can use Unpivot in Power Query Editor.

Select all the value columns in your fact table and click unpivot.

 

This will create transform your columns to rows 

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn


 

  • Julien_F's avatar
    Julien_F
    Icon for Helper I rankHelper I
    6 years ago

    Mariusz 

    It is a good idea but I think this is not resolving it... I think I going to build a table in my big query stage and not in PBI ; )