Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a matrix visual that I've added a number of filters to in the filter pane. 2 filters though are in italics, and the hide buttons are not available on them. I also cannot select them to drag them to another area. And both are repeats of filters that I already have. I started this report with the June desktop version and just noticed this problem yesterday after the July 2019 version downloaded. They both function as filters, but want to remove the redundancy.
I've already verified these two fields only exist 1 time in my model, Year in the Date table, and Customer Name in the Customers table. These are not different fields with the same name. What am I missing?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingSolved! Go to Solution.
You may take a look at Pass all filters in drillthrough.
You may take a look at Pass all filters in drillthrough.
Ahh... you are correct. If you hover over the right hand side of it, it will tell you it comes through a drill-through. In testing the new filter pane over the past few months, I never noticed it did that with drill-throughs. Thanks!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThere is definitely something wrong with filters here. If I drag the regular "Customer" name to the bottom of hte list below the redundant filters, it will put it above the the redundant filters, which I half expected. But then it will NOT let me move it back up. It is stuck down there. I had to close the file without saving to get that filter back to the top.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |