Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
4 years ago
Solved

Group Individual values & All

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. 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    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] )
    )