Create slicer

[Anonymous]

Hi everyone,

We provide our customers with one of the many contracts we have (100+). I want to create a slicer with only premium contracts (so premium contract> yes/no). I think I need to create a calculated column, but I don't know which formule works for this problem. 

I have created a subselection of our (premium) contracts. 

Contract	Premium contract
xxxgroupa	no
xxxgroupb	no
xxxgroupc	no
xxxgroupd	no
xxxgroupe	no
xxxgroupf	no
xxxsegment	no
xxxsegment(1)	no
xxxbst	no
xxxbsr	no
Platinum	yes
Gold	yes
Silver	no
Best	yes
Twocontr	yes
regularA	no
regularB	no
regularC	no
AA	yes

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

I think you need a slicer with only premium contract. You can get it without a new calculated column.

You should create a slicer visual based on “contract”. Then drag the “premium contract” field to Filter type and click “yes” in the Filter type.

If you wan to learn more about it, you can click the following link.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/#slicerFilters

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.