Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.