Forum Discussion
Matrix Alignment as per requirement change
- 2 months ago
Hi GanesaMoorthyGM ,
You must change the country to columns and then search for the option switch values to rows in the values section:
If you want to have the aggregator for the YTD and MTD you need to make the easiste way is to create a Calculation Group that would return that column and the measure inside something similar to this
Your calculation items should be similar to this ones:
YTD = CALCULATE(SELECTEDMEASURE(), DATESYTD('dim Calendar'[Dates])) MTD = CALCULATE(SELECTEDMEASURE(), DATESMTD('dim Calendar'[Dates]))You can also pickup you calculation that you have for MTD and YTD and get the calculation standard and change the calculated part for the selectedmeasure().
- 2 months ago
Hi GanesaMoorthyGM ,
Try to transpose your columns.
Or you can create a parameter for your measures and use it a your row header and the countries as your column.
hope this helps.
Hi GanesaMoorthyGM ,
Try to transpose your columns.
Or you can create a parameter for your measures and use it a your row header and the countries as your column.
hope this helps.