Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to create a container that can switch the values in a line graph?
See below:
Solved! Go to Solution.
Hi @Anonymous,
You can use selectedvalue to create a measure, just like:
Measure =
var _slicer= SELECTEDVALUE(Slicer[option to view graph])
return
CALCULATE(
MAX('Table'[Value]),
FILTER(
'Table',
'Table'[option]=_slicer
)
)
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @Anonymous,
You can use selectedvalue to create a measure, just like:
Measure =
var _slicer= SELECTEDVALUE(Slicer[option to view graph])
return
CALCULATE(
MAX('Table'[Value]),
FILTER(
'Table',
'Table'[option]=_slicer
)
)
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
@Anonymous , Are you looking for a measure slicer?
measure slicer : refer if needed
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern