Forum Discussion

DE001's avatar
DE001
Frequent Visitor
2 years ago

Matrix visual filtering and modelling issues

Hello there,

                    I have two issues that I need help with.

1) My matrix visual is not showing the option for stepped visual under Format Visual-> Row Headers(Refer to Screenshot below).

2) The matrix visual that I am trying to build should behave like a left outer join in SQL. It should show all the data from table A and the matching data from Table B. However, it's behaving like inner join in SQL by filtering out all the data from Table A and showing only the matching data from both tables. I have modelled their relationship as Many to 1 and put cross filter direction as "Single" and also tried "Show items with no data". Nevertheless, the visual is filtering the data.

 

Before adding data from Table B:

After adding data from Table-B:

Please help me out.

 

Thanks!

Need Help

8 Replies

  • audreygerred's avatar
    audreygerred
    Super User
    2 years ago

    Hi! Looks like the layout portion got moved from Row Headers to  'Layout and style presets' in formatting - expand that and change Compact to Tabular.

    For your second issue, please post a screenshot of your model view (ie joins between your fact and dimension tables) so that I can try to help troubleshoot.

     

    • DE001's avatar
      DE001
      Frequent Visitor
      2 years ago

      Thanks for answering and clarifying one of my concerns. Please find the screenshot of my model view relationship.

       

      • audreygerred's avatar
        audreygerred
        Super User
        2 years ago

        I should have been more clear - can you go to the model view and send a screenshot that shows all of the tables in your and their joins?