Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Thank you @v-rzhou-msft for your help. sorry for the delay in reply.
It worked fine.
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
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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |