Fix Target column in matrix visual

[Anonymous]

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.

[Anonymous]

Thank you @v-rzhou-msft  for your help. sorry for the delay in reply.

It worked fine.

[v-rzhou-msft]

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

[v-rzhou-msft · Accepted solution]

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. 

[AllisonKennedy]

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.