Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

matrix visual without merging in stepped layout

Hi 
Iam using matrix visual with this format in report layout  in this insurance code and group name are merging but i want to show insurance code and group name and the totals without merging like other image is their any solution .

 

 

 

7 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar

    Anonymous 

     

    You can turn off the toggle here - 

    Please let me know if this didn't work.

    • Anonymous's avatar
      Anonymous
      Not applicable

      if we use stepped layout the format will be changed like this 

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        i need in this format 
        Insurance Cd | group name 
        ML                 AAAA
        ML                 BBBB
        ------
        Yo               CCC

  • Hi @dileepkumar If I understand you correctly and you want to repeat the rows ( like the option in Excel's pivot tables) unfortunately this is not available on matrixes, only on regular flat tables.

    There is an idea about this issue, you can vote for it here:

    https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=d2a7dd51-9d8e-4474-aa31-8e73fe5d70c6

    I voted 🙂

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi is there any chance we can implement this in paginated report or report builder?

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Hi Anonymous 

        According to the linked tutorial, it seems that yes  (didn't try by myself):
        https://www.youtube.com/watch?v=NPxMcvXIIk0

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.