Forum Discussion
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...
Please find attached screenshot
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