cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ravirajkumar Frequent Visitor
Frequent Visitor

Tricky Slicer Options

I have a Fact table in SSAS Tabular model which contains column name "Flag" with only possible values Yes or No,

 

I have to create a slicer Control with Yes or No, If user clicks Yes then it should filter Only Yes records but if User Clicks in No It should display all records without applying any Filter. So can you help me how to achieve this.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Tricky Slicer Options

@ravirajkumar,

 

Add a separate table for Slicer, drag measure below to Visual level filters and set Show items when the value is 1.

Table =
DISTINCT ( 'Fact'[Flag] )
Measure =
IF (
    SELECTEDVALUE ( 'Table'[Flag] ) = "Yes"
        && SELECTEDVALUE ( 'Fact'[Flag] ) = "No",
    0,
    1
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Highlighted
Community Support Team
Community Support Team

Re: Tricky Slicer Options

@ravirajkumar,

 

Add a separate table for Slicer, drag measure below to Visual level filters and set Show items when the value is 1.

Table =
DISTINCT ( 'Fact'[Flag] )
Measure =
IF (
    SELECTEDVALUE ( 'Table'[Flag] ) = "Yes"
        && SELECTEDVALUE ( 'Fact'[Flag] ) = "No",
    0,
    1
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ravirajkumar Frequent Visitor
Frequent Visitor

Re: Tricky Slicer Options

It is not working, Can you please share sample PBIX file.

ravirajkumar Frequent Visitor
Frequent Visitor

Re: Tricky Slicer Options

Hello @v-chuncz-msft , Can you please help me with sample PBIX file, the below expression not working.

ravirajkumar Frequent Visitor
Frequent Visitor

Re: Tricky Slicer Options

I have delete the relation between them and it automaticall working thank you for the solution.