Forum Discussion
Matrix Alignment as per requirement change
Hi folks,
Currently My matrix visual is like this
As per the new requirement the alignment is expected like this
And this will be further automated in power automate to send report as mail in outlook.
Help me crack this layout
Thank You
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().
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.
5 Replies
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().
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.
Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to MFelix for sharing helpful suggestions.
Could you let us know if the suggested solution resolved your issue? If not, please share any additional details so we can assist further.
Best regards,
Community Support TeamWe would like to confirm whether the issue has been resolved. If it is still outstanding, please share any additional information so we can assist you further.
Thank you.
Resolved. Thanks!
