Forum Discussion
Column goes missing from matrix when using sort order table
Hi Everyone, I'm quite stuck on something. My data has Year, Quarter, Category, Sub-category, and Value When added to a matrix, I have a custom column order for the years using a seperate YearOrde...
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)