Group Individual values & All

[prakash11440278]

Hi Power BI Experts,

I want to group the values in a column and need to display in Slicer. How can we acheive the below result. 

[Jihwan_Kim]

Hi,

I suggest having a disconnected slicer table like below and writing the measure like below.

Also, please check the attached pbix file.

Qty total by slicer: =
SWITCH (
SELECTEDVALUE ( Slicer[Slicer] ),
"All", CALCULATE ( SUM ( Data[Qty] ), KEEPFILTERS ( REMOVEFILTERS () ) ),
"Open", CALCULATE ( SUM ( Data[Qty] ), KEEPFILTERS ( Data[Status] = "Open" ) ),
SUM ( Data[Qty] )
)

[amitchandak · Accepted solution]

@prakash11440278 , Create a new table 

Status Slicer 

Open Open

Open All

Waiting All

Pending all

Closed all

Join with status column Many to Many join. Use new table's slicer column for filter

Same approch what I have done for single select slicer with all

Single Select with Select All : https://youtu.be/plGqCEZRfXU