Forum Discussion
Fix Target column in matrix visual
Hello all, I am trying to create a matrix visual in Power BI where I have yearly Target for each month.(They are fixed for whole year) I am showing the achieved target in every month.I am unable...
Hi Anonymous
Your data model may be the same with my sample table1.
Sample Table1:
You need to transform your data model from table1 to table2 as below.
Firstly, pivot [value] column and the result is as below.
Then pivot month column and the result is as below.
Let's see the result in matrix visual.
You can download the pbix file from this link: Fix Target column in matrix visual
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous for your help. sorry for the delay in reply.
It worked fine.