Forum Discussion
Bookmark based on Button issue
- 6 years ago
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.
Hi Anonymous ,
may be you use in the first step the blank button - you can find it under "Insert" and "Buttons" -> "Blank"
there you can directly choose your Bookmark really easy 🙂
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!