Forum Discussion

GanesaMoorthyGM's avatar
2 months ago
Solved

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 ...
  • MFelix's avatar
    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().

     

     

  • mussaenda's avatar
    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.