Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
122 | |
74 | |
72 | |
58 | |
48 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |