Forum Discussion

bundipapa's avatar
bundipapa
Icon for Helper I rankHelper I
3 years ago
Solved

How to keep row header when no data

Hello,

probably another stupid question, but I would need to know, if it is possible, to keep the row header and show empty field when the line would be normally filtered out.

I have to create a matrix table and align it on a dashboard with other elements, which are not impacted by the filter.
I have different products and GEOs and we know, that in the current view product B does not have data for APJ.


It might have values for APJ in the next view so we want to keep all product groups visible, but if I click APJ in the slicer, I would like the table to show B in the row headers and have the values empty instead of filtering out product B overall.

Would that be possible?

 

 

 

Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi bundipapa 

     

    Add a Dim Product table to your model which has all distinct product values, and connect it to the original table on Product column. 

    Then use Dim Product table's Product column on rows of the matrix and select "Show items with no data" option for it. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi bundipapa 

     

    Add a Dim Product table to your model which has all distinct product values, and connect it to the original table on Product column. 

    Then use Dim Product table's Product column on rows of the matrix and select "Show items with no data" option for it. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.