Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

slicer with yes and No

i have the data as below   id    type 1     fruit 2     vegetable 3     fruit 4     fruit 5     vegetable   i am looking for slicer filter with display yes and no option.  Yes - all records...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    You can create a measure and add it to visual level filter as below:

     

    if show = IF(SELECTEDVALUE('slicer table'[slicer])="yes",1,IF(MAX('Table'[ type])<>"vegetable",1))

     

    Or create measures and add it the column chart

    Measure =
SWITCH (
    MAX ( 'new table'[slicer] ),
    "no", CALCULATE (
        DISTINCTCOUNT ( 'Table'[id] ),
        FILTER (
            'Table',
            'Table'[ type] <> "vegetable"
        )
    ),
    "yes", DISTINCTCOUNT ( 'Table'[id] )
)

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

 

1. Create a one-column table Slicer[Selection] with two rows: "Yes" and "No"

2. Place Table1[id] and Table1[type] in a table visual as you are already showing

3. Place Slicer[Selection] in a slicer visual

4. Create this measure

 

ShowMeasure =
IF (
    "Yes" IN DISTINCT ( Slicer[Selection] ),
    1,
    IF ( SELECTEDVALUE ( Table1[type] ) = "Vegetable", 0, 1 )
)

 

5. Place the measure in the visual filters for the table visual and choose to show if result is 1

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    should I create measuse for dataset Data or Table.