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 YearOrder table:

 

When adding the 'Year' column to the matrix from the sortOrder table, one of the years goes missing (2022 Actuals). If I replace it with the 'Year' from the original table, the year shows up again. Why is it going missing? I've triple checked spelling- I have no idea why it's behaving this way. Am I missing something?

I'm not having any issues with missing columns in other matrices using the same YearOrder table.

 

Need Help

8 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    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. 

    • 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.