Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Matrix Show all Null Values (Filter on Year with Month Columns)

I have a filterset for 2019 and I have a matrix with Months from the date dimension as columns. However, my data only goes up to March

 

Is there a way of showing the matrix with every Month within that year up to December even though there is no data for it?

 

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi DebbieE 

    If you go to the field in the matrix visual columns on the visualizations pane, you can select "Show items with no data" 

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi DebbieE 

    If you go to the field in the matrix visual columns on the visualizations pane, you can select "Show items with no data" 

    • DebbieE's avatar
      DebbieE
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Ah there it is when I click on the date in columns. Thank you so much