how to call a column in a slicer

[baluk]

I need a single column in  table by clicking on slicer the column should be change accordingly as per the slicer . How to achieve this please help

Thaks in advance

Spoiler

[v-juanli-msft · Accepted solution]

Hi @baluk 

Create a measure

Measure =
SWITCH (
    SELECTEDVALUE ( Display[Display] ),
    "Hour", FORMAT ( MAX ( 'Table'[hour] ), "standard" ),
    "Lasthour", FORMAT ( MAX ( 'Table'[lasthour] ), "standard" ),
    "Today", FORMAT ( MAX ( 'Table'[today] ), "General Date" ),
    "Yesterday", FORMAT ( MAX ( 'Table'[yearterday] ), "General Date" )
)

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.

[v-juanli-msft · Accepted solution]

Hi @baluk 

Create a measure

Measure =
SWITCH (
    SELECTEDVALUE ( Display[Display] ),
    "Hour", FORMAT ( MAX ( 'Table'[hour] ), "standard" ),
    "Lasthour", FORMAT ( MAX ( 'Table'[lasthour] ), "standard" ),
    "Today", FORMAT ( MAX ( 'Table'[today] ), "General Date" ),
    "Yesterday", FORMAT ( MAX ( 'Table'[yearterday] ), "General Date" )
)

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.

[Tahreem24]

@baluk ,

You need to unpivot your columns and take this columns in slicer to get your desired result. I tried to replica your scenario at my side and attched screen shot for your reference. 

Do let me know it whether it is what exactly you wanna achieve or not.

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

[baluk]

@v-juanli-msft please share the PBIX file

Thanks

[v-juanli-msft · Accepted solution]

Hi

pbix

[amitchandak]

Try

New Col =

Var _sel = selectedvalue(Display)

return

if(_sel = "hour",<>,if(_sel="Month"),<>,<>)