Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I wish to end up with a matrix like this:
Measures in bold have been calculated from my data set as calculated measures. even the header called "actual. budget and Past year". I have managed to place the ratios on the rows under the "value" box but icannot put the calculated measures of "vs budget and Vs past year" in the column. Is there a way to do this?
Thanks so much for your help!
Evie
Hi @Anonymous ,
You can put the ratios onto the Rows, and put the actual, budget and Past year onto Values.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The ratios are calculated measures and cannot seem to be placed in the rows.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |