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