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 to add Target column as fixed one.
When tried in Matrix , it is showing as Monthly (target and achieved ) for ech month, like below
Can I achieve this in matrix visual, like shown below.
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.
4 Replies
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.
You could add Target as a column to the same table as Dept Name, otherwise I don't know any way to get that layout.
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
