Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!