Forum Discussion

GAURAV7781's avatar
GAURAV7781
Icon for Helper III rankHelper III
6 years ago
Solved

How to show slicers

Area. = Var _Selected=CONCATENATEX(ALLSELECTED('Exported Data-RGA'[Area]),'Exported Data-RGA'[Area]) Return Switch (_Selected,"W","Warehouse","S","Sales","MNRSTW","Total Returns","WS","IMS Caused")

Only when i am selecting WS its not working 

 

Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi GAURAV7781 

    I build a sample table and tried your measure, I found when you select WS/SW your measure _Selected will output "SW".

    So in your return when output ="WS", the result is blank.

    I update your measure:

    Area. = 
VAR _Selected =
    ALLSELECTED ( 'Exported Data-RGA'[Area] )
VAR _CON =
    CONCATENATEX ( _Selected, 'Exported Data-RGA'[Area] )
VAR _Output =
    IF ( _CON = "SW", "WS", _CON )
RETURN
    IF (
        ISFILTERED ( 'Exported Data-RGA'[Area] ),
        SWITCH (
            _Output,
            "W", "Warehouse",
            "S", "Sales",
            "MNRSTW", "Total Returns",
            "WS", "IMS Caused"
        ),
        BLANK ()
    )

    Result is as below.

    Select "WS"

     

    You can download the pbix file from this link: How to show slicers

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    GAURAV7781 ,

    Not tested. Try like this

     

    CONCATENATEX(ALLSELECTED('Exported Data-RGA'[Area]),Switch('Exported Data-RGA'[Area] ,"W","Warehouse","S","Sales","MNRSTW","Total Returns","WS","IMS Caused") )

     

    CONCATENATEX(('Exported Data-RGA'[Area]),Switch('Exported Data-RGA'[Area] ,"W","Warehouse","S","Sales","MNRSTW","Total Returns","WS","IMS Caused") )

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi GAURAV7781 

    I build a sample table and tried your measure, I found when you select WS/SW your measure _Selected will output "SW".

    So in your return when output ="WS", the result is blank.

    I update your measure:

    Area. = 
VAR _Selected =
    ALLSELECTED ( 'Exported Data-RGA'[Area] )
VAR _CON =
    CONCATENATEX ( _Selected, 'Exported Data-RGA'[Area] )
VAR _Output =
    IF ( _CON = "SW", "WS", _CON )
RETURN
    IF (
        ISFILTERED ( 'Exported Data-RGA'[Area] ),
        SWITCH (
            _Output,
            "W", "Warehouse",
            "S", "Sales",
            "MNRSTW", "Total Returns",
            "WS", "IMS Caused"
        ),
        BLANK ()
    )

    Result is as below.

    Select "WS"

     

    You can download the pbix file from this link: How to show slicers

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.