Forum Discussion
Bookmark based on Button issue
Anonymous - I am not 100% understanding what you are asking but I will give it is shot. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
So, if what you are referring to Val and Qty are values displayed in your line chart, there is a technique called the Disconnected Table Trick that might help as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Basically, Let's say you create a table, "Choices" with a column "Choice" and two values, Val and Qty. You would use this to create a slicer. Then you could create a measure like the following:
Measure = VAR __Choice = SELECTEDVALUE('Choices'[Choice]) RETURN SWITCH(__Choice, "Val",SUM([Val]), "Qty",SUM([Qty]) )You would use this Measure in your visualization.
Greg_Deckler Is there anyother way to toggle between the Val & Qty by Time Wise
Anonymous - I am not 100% understanding what you are asking but I will give it is shot. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
So, if what you are referring to Val and Qty are values displayed in your line chart, there is a technique called the Disconnected Table Trick that might help as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Basically, Let's say you create a table, "Choices" with a column "Choice" and two values, Val and Qty. You would use this to create a slicer. Then you could create a measure like the following:
Measure =
VAR __Choice = SELECTEDVALUE('Choices'[Choice])
RETURN
SWITCH(__Choice,
"Val",SUM([Val]),
"Qty",SUM([Qty])
)
You would use this Measure in your visualization.