Hi Everyone,
as show in the picture , the 3 selected values are from 3 tables (CF,PF,PY) I want the CF value to be constant , and have a button to switch between PY&PF , but PBI is not allowing me as this switch is only alloweed if am inserting two choices in the (Axis) field not the (Value) field.
so please suggest what can be done as i been stuck in this for weeks now.
thanks for the support!
Omiama.
@Anonymous it is ok if those are different table, here is updated measure
PY or PF= VAR __selection = SELECTEDVALUE( SlicerTable[Value] ) RETURN IF( __selection = "PY", SUM( TablePY[Value] ), SUM( TablePF[Value] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous you can achieve this by using slicer, add new table with two rows, PY and PF. Put this as a slicer, add following measure
PY or PF= VAR __selection = SELECTEDVALUE( SlicerTable[Value] ) RETURN IF( __selection = "PY", [PY Measure], [PF Measure])
now use this new PY or PF measure in your visual and value will switch based on selection in slicer.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks for ur answer, but as shown below PY&PF are tables, and the values in them are in columns named (Value) so what can i do in this case ? 😞
@Anonymous it is ok if those are different table, here is updated measure
PY or PF= VAR __selection = SELECTEDVALUE( SlicerTable[Value] ) RETURN IF( __selection = "PY", SUM( TablePY[Value] ), SUM( TablePF[Value] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
