Forum Discussion
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
No - exclude vegetables.
Can anyone help how can i do this.
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.
9 Replies
- mahoneypat
Microsoft Employee
Assuming you have a disconnected table called Slicer (e.g., use Enter Data to make a table with Yes and No, and have no relationships to other tables), you can use a measure like this to get your desired result:
SlicerCount = if(selectedvalue(Slicer[Decision]) = "Yes", countrows(Data), Calculate(countrows(Data), Data[Type]="Fruit"))
This also assumed your table is called "Data" and the Slicer column is called "Decision".
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Here are the steps i followed.
1. Created a table with Slicer and column Selection with roes Yes and No.
2. Created a measure under table SlicerCount with the formula you provided.
3.added a Visual Slicer for selection.
4. when i click Yes and No . row counts are same.
Please let me know where i missed.
- AlB
Community Champion
Anonymous
Step 5
5. Place the measure in the visual filters for the table visual and choose to show if result is 1
https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/
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
- AlB
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
v-juanli-msftCommunity Support
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.
rock_stage_userHelper I
how we can give the multiple catgories in measure like vegetables,fruits
- rock_stage_user
domain
yopmail.com
yahoo.com
gmail.com
agency.com
i am looking for slicer filter with display yes and no option.
Yes - all records
No - exclude yopmail.com and yahoo.com.
can someone pls help me. how to do this
