Bookmark based on Button issue

[Anonymous]

Hi All,

I have created bookmark based on the button val and vol by hour,day... etc.

my pic is DAY wise.my issue is when i click Hour and trying to see value , its again coming back to DAY, i want to see HOUR wise Val and Vol, same for all the time slicer

[KBO]

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!

[amitchandak]

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.

[Anonymous]

@amitchandak 

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

[Greg_Deckler]

Tough to follow. Bookmarks can be tricky sometimes, make sure you have everything setup exactly for Hour the way you want and then update your bookmark. Very difficult to tell what is going on.

[Anonymous]

@Greg_Deckler  Is there anyother way to toggle between the Val & Qty by Time Wise

[Greg_Deckler · Accepted solution]

@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.