Editing Filter Values

[Anonymous]

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 below 80 as "Less Than 80".

On the dashboard I am creating, I applied a filter based on this column. However, there is no data in the table currently, that has a score between 80-90. Because of this my filter is only showing the following values: "90-100" and "Less than 80". But I want the filter to show "80-90" as well.

What should I do?

[edhans]

Your 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.

[camargos88]

Hi @Anonymous ,

Try clicking on the column and select "show itens with no data".

Did I answer your question? Mark my post as a solution!
Ricardo