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.
Refer if this can help.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Provide more information to help. It is not very clear.
I have Val and Qty chart with 2 buttons respectively , in another chart i have sales analysis by Hour,Day and so on
when i am in seeing the sales analysis by Hour i should see qty and val (based on clicking val and qty button) and same when i am in Day i should see qty and val. and so on for other Time button
the problem is when I am looking at Hour and trying to click the qty button , it taking me to DAY wise chart.
hope i am clear this time