Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
When I filter specific columns in my matrix, the data in other columns becomes blank. My matrix is based on two tables, a factTable and a dimTable. My dimTable contains a delivery number that forms a one-to-many relationship with my factTable. My factTable includes a series of milestones that I want to be able to filter in the filter pane. However, when I filter one milestone, the data disappears in the other columns.
My model.
This is what my matrix look like without any filters.
This is what my matrix looks like after filtering. I would like to ensure that the relevant data in the other columns remains visible when I filter a specific milestone (in this case MP1). Is there a solution to address this issue?
Edit: The columns MP1, MP2, etc. are text fields derived from a date column in my table. I am utilizing the date column for filtering purposes, and I am uncertain if this has any influence on the issue I am experiencing.
Hi @TobiasR ,
If I understand correctly, the visual can display the data normally without the filter. But after add some filters on the field [MP1], the fields expect [MP1] not display the data. Am I right? Except the filter in the below screenshot, is there any other filter exisit in your report?
In order to make troubleshooting and give you a suitable solution shortly, could you please create and share a simplified pbix file with us? You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
86 | |
85 | |
68 | |
49 |
User | Count |
---|---|
139 | |
112 | |
104 | |
64 | |
60 |