matrix visual without merging in stepped layout

[Anonymous]

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 .

[Ritaf1983 · Accepted solution]

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 · Accepted solution]

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]

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

[Ritaf1983 · Accepted solution]

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]

@Anonymous 

You can turn off the toggle here - 

Please let me know if this didn't work.

[Anonymous]

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

[rajulshah]

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

[Anonymous]

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