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 ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

     

     

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Anonymous 

 

You can turn off the toggle here - 

Please let me know if this didn't work.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Anonymous That is not possible in Power BI using matrix. You can use Table visual or can explore custom visuals.