Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
@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!
Try
New Col =
Var _sel = selectedvalue(Display)
return
if(_sel = "hour",<>,if(_sel="Month"),<>,<>)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |