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
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
