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
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Julien_F ,

 

Sorry for that we cannot understand your requirement clearly, you want convert fact table to which kind of data model , the row based or column based? Does the construction of your data model similar to the data model in the sample you shared? Do you mind to use Power Query Editor to convert the data?


Best regards,

 

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

v-lid-msft 

Yes I would like to transform my fact into a fact like yours ( Rows based) . The think is in a star schema model you don't have a model like yours where KPI are in the same colunm, is it clearer?