Lock the slicer options

[edubcardoso]

Hey, I have a slicer that is based in a calculated column that I use to filter some tables. That column "Equal" only have 2 options, Yes and No. In some months only appears one option, but i want to appear always Yes and No in the slicer. 

It is possible to do this ?

In May,

In April,

 

The table i used to build the example.

Sorry for my English !

Thanks for any help!

[Anonymous · Accepted solution]

Hi @edubcardoso 

You can create a table using Enter data and map that table with the one which has email column.

And use the Email column from new table , that way u'll always see yes and No.

[Anonymous · Accepted solution]

Hi @edubcardoso 

You can create a table using Enter data and map that table with the one which has email column.

And use the Email column from new table , that way u'll always see yes and No.

[edubcardoso]

I'm sorry, but it didn't get it.

What do you mean by "email column" ?

[truptis · Accepted solution]

Hi @edubcardoso , 

Since in the data for April, you have only "YES" value it is showing one thing in the slicer. If you want to show both "YES" and "No" then you can follow the below steps:
1- create a new table using enter data:(screenshot -> click on enter data -> enter values-> load):

and then click on load.

Step 2:
make a relationship between this new table & "Equal" column:(screenshot) Modelling -> Manage Relationship 

make relationship between Equal column and the new column that is coming from the new table that we created
Step 3: take value in the slicer from the new table.

@edubcardoso -> Please hit the thumbs up and mark it as a solution if this helps you. Thanks.

[edubcardoso]

It worked!!

Thanks truptis 😊