Group by measure in colum

[gadielsolis]

Hello community.

Im working in a matrix using 3 measures (Measure1, measure2 and measure3) and I'm using the month field from the calendar in columns therefore the matrix will group the 3 measures by month (Month1 - Measure1, Measure2, Measure3||Month2- Measure1, Measure2, Measure3...etc). Is there any way I can group this by measure and show Measure1-Month1, Month2, Month3|| Measure2-Month1, Month2, Month3... etc.

Thank you in advance for the support.

[OwenAuger · Accepted solution]

Hi @gadielsolis 

I would recommend creating a calculation group to be used for measure selection, along the lines of this article.

https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/

Then you can create a visual grouped by the calculation item column first, followed by month, with an arbitrary measure (which will be overridden by the calculation items).

Are you able to get that working?