Forum Discussion
Center Matrix
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?
3 Replies
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
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
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.
