Forum Discussion
Filter Doesn't Works
My filter does not show the dataset options, even with the dimension table correctly classified. What is stranger is that the options appear from a date, and others do not. The fields selected in th...
This can be a number of things.
- You have blank values it seems in your DIM table. That is never good. You shouldn't have data in your FACT table not in your DIM table unless you intend to, and then you will be using different measures for calculating values, and you cannot use filters/slicers efficiently since those don't exist in the DIM table.
- Could be spelling differences, or spaces. Is it "Shopping" in one table and "Shopping " in your other table?
- I am not clear on how that bi-directional many-to-many is affecting the model for these particluar fields.
There could be other issues too. Without the PBIX, just tossing out things for you to look at.
Your FACT table isn't (shouldn't) be filtering your DIM tables. You need to put your Store ID from the DIM table it is in. Never use fields in your FACT table for filtering, slicing, etc. In fact, I generally hide all fields in the FACT table not directly used for reporting, and that is usually just text fields. Any numerical fields I convert to an explicit measure to prevent any implicit measures. Then I hide all of the numerical fields.
The same is true when using the dimension table ID_Store. The problem is not there.