Forum Discussion
Need Help Creating Matrix based on Goal v Actual
Hi JP_G ,
You can refer to the following steps:
1. In the power query editor, hold down the CTRL key, select these four columns, and then click the unpivot columns button. Both tables perform the same operation.2. After applying the results to desktop, create a relationship for two tables.
3. Place the appropriate fields in the matrix and rename them in the visual object.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JP_G ,
You can refer to the following steps:
1. In the power query editor, hold down the CTRL key, select these four columns, and then click the unpivot columns button. Both tables perform the same operation.
2. After applying the results to desktop, create a relationship for two tables.
3. Place the appropriate fields in the matrix and rename them in the visual object.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Clara,
Thanks again for the help! That worked well. When it comes to data formatting with this situation - I'm trapped by having all my metrics in one column right? Any good way to pivot another way to that I can apply data formatting to certain Attributes.