Replicating an excel table in powerbi

[SGV]

Hi guys,

How do i replicate the below table in power bi? I have tries using the matrix visual but it splits all the pre and post KPIs.

[SGV · Accepted solution]

Hi, i figured it out. I had to create measure for each column and used a matrix

[v-yiruan-msft]

Hi @SGV ,

Thanks for your feedback. Could you please mark your post as Answered since you have solved it? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[v-yiruan-msft]

Hi @SGV ,

How did you set your visual? Could you please provide some raw data (exclude sensitive data) with Text format which applied on the visual? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards