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...
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
bcdobbs
Community Champion
Community ChampionNot 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.