Forum Discussion

Vamshi_R's avatar
Vamshi_R
Frequent Visitor
6 years ago
Solved

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

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

Need Help
  • Vamshi_R's avatar
    Vamshi_R
    6 years ago

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

3 Replies

  • Vamshi_R's avatar
    Vamshi_R
    Frequent Visitor
    6 years ago

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

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Vamshi_R
      Frequent Visitor
      6 years ago

      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.