Forum Discussion

Vishruti's avatar
Vishruti
Helper I
10 months ago
Solved

Matrix Visual to Display Columns where Data Does not Exist

I have data (as given below) (also attached in Excel).

 

The data is about Products, Product Type and Quarter-Year.

For one product, there may be multiple Product Types for the same quarters or multiple quarters. Or for a particular product, there may not be any product type given for a particular quarter.

 

I want to create a Matrix visual with Product on Rows, Year-Quarter on Columns and Product Type in the Values.

I have a date slicer. Whichever range user selects from the date slicer, I want to show only 8 quarters in matrix visual based on the minimum date selected in the filter. (Min selected included).

 

The main problem is, if a particular quarter does not have any record for any product then that Quarter column is not displayed. I want this column also to be seen with either a blank space or "-" like below

 

https://docs.google.com/spreadsheets/d/14aknAb9mBGgQwMongOs7QBkW45npasmMUYX-1_bhqrw/edit?usp=drivesdk 
How can I achieve this? 

Show and Tell

6 Replies

  • MFelix's avatar
    MFelix
    Super User
    10 months ago

    Hi Vishruti ,

     

    When you have values on rows or columns that don't have data but you want to display them as well you need to right click that specific column and select the option show items with no data:

     

     

      • MFelix's avatar
        MFelix
        Super User
        10 months ago

        Do you only have a table on your model?

         

        Create a dimension table with all the quarters and related it with your fact table then use the quarters from the dimension on your visual should give rxpected result

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    10 months ago

    Hi Vishruti  ,

    I would also take a moment to thank MFelix , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

    • v-sshirivolu's avatar
      v-sshirivolu
      Community Support
      9 months ago

      Hi Vishruti ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you