I've done this in a report and my end users LOVE it! Now the trouble is backporting the feature to older reports...

We use this a lot. It’s become a common part of our designs to have View icons under the chart. Usually small circular buttons with ‘#’ Number, ‘%’ Percentage and ‘T’ Table views. We often use the same for ‘M’ Month, ‘W’ Week or ‘D’ Day views as they’re easier for users than drill down mechanics and makes it possible to customise the x axis in particular.

Great Patrick, as always. I think the real game changer would be to be able to conditionally show/hide visuals based on a custom DAX boolean expression for instance

This is great specially for those users who struggle with the personalize visual option. Thanks for sharing!

I have a report much like that, I definitely like the data checkbox to switch visuals. I like to give the user some steps to follow, first you must click to filter, once you filter display a matrix and some field data as well. It helps the users really interact with their data.

This channel is like wine: as it gets older, it improves

Yes we use that. We also created a filter menu that basically opens up a shape on the left with buttons and cancel button to close the pane out. You can add slicers, buttons etc to it. Saves space on the visual space.

I have not tried this, but this will solve a problem my group has been having. I look forward to trying this approach.

You are right, this is a great feature. I have been using it for years now, and it's generally really appreciated. However, this is also a gateway to multiple problems, and it should be very carefully considered before being implemented. On the user side, this can cause your reports to be slow, especially if you give too much information on a single page. On the developper side, maintaining and updating this becomes a bit more tedious, as you need to take into account more visuals, that are hidden behind one another. But all in all, this is still a very useful tip, that can bring life to some amazing reports !

Use this all the time and it seems to be a winner with most of my viewers!

This is been implemented in our reports a while ago. We gave option to toggle between line and bar charts. But I like the new functionality of Dynamic parameters

Power to the people! Love this combo of field parameters combined with bookmarks!!

The great thing about field parameters, and the much-loved SWITCH workaround that preceded it, is that it takes a fairly static looking report and gives the user the power to play with it. In my experience, a lot of the reluctance to move from Excel to Power BI is that people can feel they are losing the ability to play with and explore data. Moving to Power BI is good for forcing people to come up with a good idea of how they need to look at something, but can mean that they only get that view; they stop being an analyst and start just being a consumer who gets given a number on a set schedule. The parameters allows uses to get back the level of control where they can ask questions of the data and not feel like they'll just end up downloading the dataset into a pivot table once they need to conduct deeper analysis.

Great combo of using bookmarks and field parameters. If we can make bookmark navigation by using any slicer selection that would be a game changer feature. We won’t need extra button to achieve those if implemented.

Patrick, this is a nice synthesis of the powerful interplay between Field Parameters and Bookmarks. Thanks for posting

Superb feature. I will definitely use this feature in our reports

Totally makes sense, been asked for that and got stuck at loosing the filters all the time grrrrrrr 🙂 Great video as always thx !

Love, love, love this!

You are the greatest for making this video. Thank you so much!

This is really cool idea Patrick. I think it is a great way of showing variety of charts based on selection

Hi Patrick Totally It's pretty bananas!!!

Great feature! I'm allready using this a ton and it is adding a lot of value to my users. My life got 10x easier with the field parameters. I went from about 20-40 bookmarks to more like 10 (for similar functionality as above). What I'm really hungry for is instead a way to use code to build the layout and set up the visuals. I want to use code to position, set settings for the visuals, add the x, y values/measures etc. Then I could spit out, modify and update reports much more efficiently. Just think about the ability to allow multi language for the same report. Just some search and replace and then you have a copy in another language. And with code those things could be automated and put into CI! Now I have to use the tedious visual GUI to set all of this up. The bookmarks for example that you display here, it is such a pain to do it! Shure it's cool and gives tons of freedom, but it is still pain! Are there any plans on opening up code for the programming of the GUI (visuals etc.)??

I have done something like that. But instead of a normal slicer, I change it to Chiclet slicer (I think it looks prettier after some fancy formating). And I use 3 field parameters, one for X axis, another for Y and a 3rd one for the value. Doing this to give users as much flexibility as I can.

Like it ... now where to use ...

I love the effort and the input you guys put into every video! You guys rock! We need to show you a few things we are developing; you might get inspired to publish a video or two. 😉

This is very good I'm implementing with to multiple departments of my company right now!

This is niceeee! But is there a way to create a sublevel for each parameter?

Wel this is excellent functionality and workarounds.. I used it earlier.. the only problem in my opinion is that you need to make multiple bookmarks for each visuals.. so if the report has many report pages and as well many visuals included.. this will end up with tens or hundreds of bookmarks

I did something like that for a while, but my report have about 200 distinct users and they all have personal preferences and data needs, managing the bookmarks and field parameters just became too much. I went back to activating the "personalize visual" button and now they have access to everything and they can do whatever they want with it.

Please make a video on Charticulator...

Good Feature. Maybe consider changing button text with pictures of visual types

nice way to use field parameters.

Hey Patrick.. first of all the videos are awesome . Appreciate. I have a question. How to use a calendar slicer when that calendar has bind variables

I'd love to see Power BI Visuals able to be referenced in field parameters. Bookmarks get messy, especially when adding new visuals into different bookmarks.

Good luck Bro

Great idea. I will definitely be using this 😊

Thanks!

A problem I have with bookmarks is that the "data" option you showed only works for slicer visuals. If I have say a bar chart, and I click one bar, I cant persist that across bookmarks. The filter context always resets in this scenario.

This is really really helpful

Hey Patrick, I have built a 'golden' dataset in my org that we will use as a base for multiple reports. I've learned that in order to create Field Parameters you need to modify the dataset, but mine is quite big and has IR set on it. Is there a way to create these Field Parameters without re-uploading the dataset to the service and without creating a separate 'composite' (Direct Query to dataset) dataset?

Bananas is right. That was crazy cool. Thanks for the video!

A great video! I am encountering a problem with default gauge visual. The requirement is to have a card visual in the middle of the gauge visual to show the remaining value. As work progresses, the current value would move from left to top and to right. This leads to the gauge's ring moves as work progress which causes the card visual off-center. The dashboard does not allow interactive clicks, so bookmark is not likely to solve the problem. What would you do?

Im still looking but their may already be an answer. I will be showing graphs to a multilayer heirachy. I would like to limit each user to only see their day going down. This seems to be a case of duplicating the report multiple times and excluding all data not applicable to that user, likely at the query or the overall filter

Great!!

Is there an option to filter different data in different visuals.

DOPE! Thank you!

Thanks Patrick!..A quick question..Is there any way to use this bookmark switch in dashboards as well?It would be a game changer then.

i have done all thr steps but the graph is not showing. Any help ?

Bookmark navigation, what if there's a slicer panel in the page, (Adam has a YT video on it) and want to conditionally select bookmark in the navigator.

Where I am struggling a bit with this approach, in contrast to the "Personalize visuals" function that became GA in October 2020, is visual cross-filtering behavior. The selection on charts that are hidden or in the background still apply to cross-filtered visuals. It can get confusing for the user to understand when cross-filer selections are applied or reset when switching between bookmarks showing or hiding visuals with an active cross-filter selection. Let's assume next to the area with the switchable chart type there is a card visual showing a KPI. What cross-filter interaction settings would you recommend between the switchable charts and between each switchable chart and the card visual and why?

Question :if I Drill down in page 1 ,I need whole report to be filtered based on drill down?

This is exactly what I was looking for. Bananas!😀👍

Wow this videos is Bananas!!! One more time you help so much in my journey in learning power bi

Looks neat, but feels like it's just an extension to Adams' 'Mastering PowerBI Bookmarks' video.

The same can be done if you use "selected visuals" in bookmarks

When is the field parameter feature becoming GA ?

Powerful but also dangerous how much you can achieve using bookmarks

Greeeeeeeaaaattt video!!!

Genius, it's great

Can we get back removed data gateway In power bi

Didn't Adam made already a video about this? 🤫

Amazing

❤

Woww, can you help me for pl 300 exam?

I have already used this at my customer's place...

Like

🍌🍌🍌🍌🍌🍌

Hi, I really admire the content of your videos, but you speak and act too fast that I cant really understand the steps you used that sometimes I miss the whole point.

Essentially just book.arms. nothing new at all!!

this will decrease the number of visuals or sheets on the fist glance that sometimes even scared the users :D