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

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:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I have dummy data in 2022 Actuals for testing purposes. When I select show items with no data, 2022 Actuals shows up but is indeed blank! When I replace 'Year' in the matrix with the one from the data table, 2022 Actuals column shows with the dummy data, so the mystery remains

      with Year from YearOrder table

      with Year from Data table

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        Share the link from where i can download your PBI file.