Center Matrix

[RobbLewz]

I have a Matrix that will grow in width depending on what dates are selected in my slicer.

I always want to keep the Matrix data cantered and display all data (no scroll bar at the bottom) but can't find way to do this.

I can select the visual and centre align it from the format menu, but this aligns the visual area, not the actual matrix grid data.
This is fine for a static grid but as my grid changes with the slicer selection, then this doesn't work.

What I need to do really is set the visual width to be the width of the page and then centre align the actual data but I can't find a way to do that.

Has anyone found a way to configure this?

[RobbLewz]

The worting wont help, its the size that changes,. I.E as you enter a new month then that month will appear in the matrix.

I need a way really to treat the visual as a <div> and center the actual table but it doesn't seem like that is an option at the moment

[v-jingzhang]

Hi @RobbLewz 

I'm afraid this is not supported currently. You could post a new idea at Ideas (powerbi.com).

Additionally, if the number of columns will not change when selecting different options in your slicer, you may try turning off Auto-size column width, and adjust column width to a proper size manually. Then locate the matrix visual at the center of the canvas.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[amitchandak]

@RobbLewz , I dobut it will stay in middle.

One thing you can try is you sort your column(pivot) desc so that it show latest data first

Date 1 =[Date]

Date sort = rankx(all(Table),[date])

Sort Date 1 on date sort and use on column if you are using date on column