Exposed columns without drill down

[Anonymous]

Community:

I am currently working on a Power Bi financial report an I have gotten stucked with my Matrix layout. My intention is to add different fields into the column section, however when I do this power bi automatically picks the first and consecuently only lets me drill down. I want to be able to expose my columns in a progressive manner (from left to right) therefore be able to visually compare figures from columns without having to "drill".

Thank you in advance! 

[amitchandak]

@Anonymous 

Refer :https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[bfernandez · Accepted solution]

You can accomplish this by going to the Format option of the matrix visual.

Go to the Row headers dropdown, and toggle the Stepped layout to the Off position.

Then drill down to the levels you would like and it should provide the output you're looking for!

You can even enable and disable the +/- icon as well.

@Anonymous Please mark this post as the solution if it accomplished what you needed so it can help others! 😁