Forum Discussion
Matrix visual filtering and modelling issues
I just have those two tables. Should I still send a screenshot of the model view?
Which one are you considering table A and which are you considering table B (as referenced in your original post)?
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
I believe this answers the filtering issues I am having with my visual. Let me explain what I am trying to do here and what the business requirement is. All the data I want on this visual is coming from Direct Query which is in Table A. But my internal clients requirement is to add the user input priority on to the matrix visual of Table A. Therefore, I created a Power app with which user can input priority values to the wave number and then display it on the matrix. However, I don't want this Table B (user input priority)values to filter Table A. What will be the best approach to solve this issue?