The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 2023
if year is 2022
if the plant change
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
thanks for the answer, these are example data, which present the same problem.