Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created a matrix report as shown below:
Now I need to add below 2 columns to the above report for the month of April(Latest Month) only.
However if I add above 2 fields to the 'Values' section, it gets distributed to the months columns and looks like below :
please advise on how i can add the fields to the report so that it shows data next to the latest month column only and not for other months.
the final output should be something like below :
Thanks in advance.
Solved! Go to Solution.
Hi @smegha646
Unfortunately, we don't have the option to add measures as another column in the matrix.
But there is a workaround with dynamic measure that you can apply to get the desired result.
These are the steps that you can apply :
1. Create a table with the 2 measures that you need to add to the end of the matrix :
2. Append it to the table with the categories that you have on the matrix's columns :
Note: the columns' names should be the same :
3. at the new table (result of append), remove all columns except for categories :
4. remove duplicates:
5. Switch off the enable load of the "measures table", you don't need it :
6. add an index column, you will need it to sort the columns of the matrix:
7. close and apply, and note that the table should be disconnected (with no relationship):
7. create 3 measures :
1 for the "columns" that you have now and 2 for the new measures
8. create a dynamic measure for a matrix using our new table as a condition :
9. sort the column of categories + measures by index :
10. create the matrix :
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @smegha646
Unfortunately, we don't have the option to add measures as another column in the matrix.
But there is a workaround with dynamic measure that you can apply to get the desired result.
These are the steps that you can apply :
1. Create a table with the 2 measures that you need to add to the end of the matrix :
2. Append it to the table with the categories that you have on the matrix's columns :
Note: the columns' names should be the same :
3. at the new table (result of append), remove all columns except for categories :
4. remove duplicates:
5. Switch off the enable load of the "measures table", you don't need it :
6. add an index column, you will need it to sort the columns of the matrix:
7. close and apply, and note that the table should be disconnected (with no relationship):
7. create 3 measures :
1 for the "columns" that you have now and 2 for the new measures
8. create a dynamic measure for a matrix using our new table as a condition :
9. sort the column of categories + measures by index :
10. create the matrix :
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks a lot, it was of great help 🙂
Happy to help 🙂
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |