Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
bcdobbs
Community Champion
4 years ago

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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:

     

    • bcdobbs's avatar
      bcdobbs
      Community Champion
      4 years ago

      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)

      • bcdobbs's avatar
        bcdobbs
        Community Champion
        4 years ago

        Try this: