Forum Discussion
Column goes missing from matrix when using sort order table
Is it possible there's a hidden space or carriage return coming in on your main table?
If you go into power query, right click the column and use the "TRIM" option and just to be sure "CLEAN" option in the transform to throw away any weirdness I'm hoping it might spring into life.
Your solution makes sense but unfortunately it didn't work . I cleaned and trimmed both YearOrder and the data table but the column is still missing
Not an obvious one!
Few questions on things to check:
Is anything lurking in the report/page filters?
Are any other visuals/slicers interacting?
Are you using a measure in the matrix. If so can you share. Wondering if it is returning blank for some reason.
1. There are no filters
2. I put the visual in a new page - nothing is interacting with it
3. There are no measures:
I filtered the visual using YearOrder table to only show the missing column and the matrix returns a blank:
Just realised it's 2022 Actuals...
Presumably you have no data for 2022. Value is therefore blank so it will hide.
I think if you click arrow on "Year" in the column section there should be a show blanks. (Will check wording when next on a computer)