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

       

       

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