Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 37 | |
| 35 | |
| 35 | |
| 28 |
| User | Count |
|---|---|
| 134 | |
| 101 | |
| 71 | |
| 67 | |
| 65 |