cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Roseventura
Responsive Resident
Responsive Resident

Field Parameters or Bookmark?

I know about, have used and love the new Field Parameters.  But I have a situation where I'm not sure if Field Parameters can do what I need.  Perhaps I should use a Bookmark instead?  

 

Would love some insight into this.

 

I have a page on my report that shows 4 separate visuals for the following:

Total Open Sales $

Total Open PO's  $

Total OH Inventory  $

Total Open Backlog $

 

Each one shows $ value.  Someone recently asked me if I provide a toggle where the visuals can switch between showing $ and Qtys.  In other words, have ALL the visuals flip between $ and Qtys.  At first I thought Field Parameter, but how would I incorporate all of the above into one field parameter?  That would involve 8 measures.

 

Should I just use a bookmark and create a Bookmark navigator that switches between the $ and Qty views?

 

Let me know if you need more info or an example.

 

Thanks.

 

1 ACCEPTED SOLUTION

I ended up replicating each of the visuals - one for $$ and one for Qty, then I created a Bookmark Navigator button which when used shows/hides the $$ or Qty visuals depending on which button they chose.  (Sorry had to hide all the good stuff - company policy).  

 

The first one is what users see when they click on Qty.

A&PQty.JPG

 

The second is what users see when they click on $$.A&P$.JPG

 

View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@Roseventura glad you have the solution but I would have used CG than bookmark and the reason for that is if you make a change in the visual you have to make sure it is done on both the pages, with CG, it is easy to switch between measure without having another page, etc. Anyhow, not a bad solution but not something I would recommend.

 

Nonetheless, the solution is a solution if it works. Cheers!!

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

jgeddes
Solution Sage
Solution Sage

In my opinion this becomes a design choice. 
I do not think you could use one field parameter to control the four visuals but you could definitely use four field parameters to control each of the visuals. That would allow your user the ability to switch the visuals independantly between $ and QTY. 
If the user wants all visuals switched at once then a bookmark would be the way to go. 
Adding four field parameter slicers also adds a bit of extra clutter to the report where a bookmark can be handled with a single button which may be easier to incorporate into the existing layout.

Best of luck with whichever path you choose.

I ended up replicating each of the visuals - one for $$ and one for Qty, then I created a Bookmark Navigator button which when used shows/hides the $$ or Qty visuals depending on which button they chose.  (Sorry had to hide all the good stuff - company policy).  

 

The first one is what users see when they click on Qty.

A&PQty.JPG

 

The second is what users see when they click on $$.A&P$.JPG

 

parry2k
Super User
Super User

@Roseventura you can easily achieve this by using CALCULATION GROUPS,  check CG playlist on my YT channel here https://youtube.com/playlist?list=PLiYSIjh4cEx2s8-jXBhv5aCu5_6F9zQ3I

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors