Table with multiple measures need to display as groups or multiple sections.

[Vamshi_R]

Hi Friends, 

I have a table with measures related to new claims and closed claims (LY, CY, variance etc..), I can show them simply in a table keeping all in Values. However my problem is to show them section wise as New cliams with grid title and show all measures related to new cliams under it and closed claims follows.

I tried explain the situation in image attached. Any help will be great..Section header for group of measures

[Vamshi_R · Accepted solution]

I solved it....using variables and measures...Thank you all

[v-juanli-msft]

Hi @Vamshi_R 

If you'd like to show all measures on rows, you can follow guides below:

Add [Month] in the "Row" of the Matrix visual, 

all Measures in the "Value" of the Matrix visual,

then turn on "Value"->"show on rows".

If you'd like the following format,

please share your table struture and how to create the measures (LY, CY, variance ,,ect) so that i can test and provide solutions.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vamshi_R]

Hi Maggie, thank you for your response. 

I tried your steps but its ending up two column with all the measures falling under each month.