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 belo...
Need Help
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?

DE001's avatar
DE001
Frequent Visitor
2 years ago

I just have those two tables. Should I still send a screenshot of the model view?

  • audreygerred's avatar
    audreygerred
    Super User
    2 years ago

    Which one are you considering table A and which are you considering table B (as referenced in your original post)?

    • DE001's avatar
      DE001
      Frequent Visitor
      2 years ago

      Please find attached screenshot

       

       

      • audreygerred's avatar
        audreygerred
        Super User
        2 years ago

        Since Table B is your dim table, it filters Table A which is your fact. Table B should contain every Wave Number in it (right now it looks like it only contains 3), and when you use Wave Number in your visual, it should come from Table B, not from Table A. Your fact table should only have keys and values. Everything else should be in dimension tables. Understand star schema and the importance for Power BI - Power BI | Microsoft Learn