How to show slicers

[GAURAV7781]

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 

[Anonymous · Accepted solution]

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. 

[amitchandak]

@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") )