Forum Discussion
Anonymous
6 years agoNot applicable
Editing Filter Values
Hi, I created a column in my dataset called 'Score Bucket'- this categorizes anything from the 'Score' column that is between 90-100 as "90-100", anything between 80-90 as "80-90" and anything be...
edhans
Community Champion
6 years agoYour filter should be using a DIM table that has the values you want to show, then it would have a 1:many relationship to your data. It would always show what is in the DIM table.
You generally should not create slicers and filters using your FACT table. See this article for more info. Basically, design everything as a Star Schema. When I do a model, my goal is to ultimatly hide every column in my FACT table and never use it for visuals, just for data in measures. I try to never use fields in my FACT table for anything other than measures.