Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Cheis
New Member

matrix and slicer problems

Hi everyone,

I'm trying to filter a matrix using two slicers: YEAR and PLANT.

Using PLANT the matrix shows values correctly, but if i use YEAR, the columns' width change even if auto-size is off.

Additionally if I copy-paste a matrix from another file in this file and I use the same settings of the previous one, columns' width change in the same way (before that change was "random").

 

Values in the matrix are measures with 4 values that shows the 4 previous years (based on the slicer).

A "matrix" is composed of 3 matrices one above the other, which have "Year" in Columns and "Percentage" in Values.

 

I checked settings and connections but I didn't find anything, what should i do?

My Power Bi knowledge isn't high so maybe what i want isn't possibile.

 

Thanks a lot

if year is 2023if year is 2023if year is 2022if year is 2022if the plant changeif the plant change

 

2 REPLIES 2
MFelix
Super User
Super User

Hi @Cheis ,

 

If you have the auto size off then everything should work properly can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi,

thanks for the answer, these are example data, which present the same problem.

https://we.tl/t-IFMst1pidD 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors