Forum Discussion
KPI Dashboard from Excel
Hi Anonymous ,
The merged cells will be automatically split when loading the data. The first row will have value and others will be blank as you can see in below screenshot.
Then you can use fill down feature in Power Query Editor to fill the blank rows with values.
In addition, through Power Query Editor, you can clean and shape the data as much as possible to make it became whatever you need. For more details, please check the document.
https://docs.microsoft.com/en-us/power-query/power-query-ui#the-power-query-editor-user-experience
Best Regards,
Jay
Hi Anonymous ,
The merged cells will be automatically split when loading the data. The first row will have value and others will be blank as you can see in below screenshot.
Then you can use fill down feature in Power Query Editor to fill the blank rows with values.
In addition, through Power Query Editor, you can clean and shape the data as much as possible to make it became whatever you need. For more details, please check the document.
https://docs.microsoft.com/en-us/power-query/power-query-ui#the-power-query-editor-user-experience
Best Regards,
Jay
Thanks for your help. That is making sense. Is there a way I can then display the table without listing the same KPI name multiple times. So it looks very similar to the original excel table with the KPI listed once and the data points listed under the correct KPI?
Hi Anonymous ,
Sorry for the delay.
Matrix visual should suit your needs.
Best Regards,
Jay