Came to say this. I used this before, but currently, field parameters do it in a second. Why torture yourself. :) However, for people who have a lot of time to deal with the design of reports, this way, you have way more chances to make it look prettier. But most of us don't have that luxury much. :)
@@omer1712 True, but there is a trick. You can add custom sorting measure to the vizualization in tooltip field. Then you can sort it regardless of field parameter selection
@@omer1712 you can sort field paramenter, change the index manually in the dax code You can even add another key, link it to another field parameter (with the mathcing key), and now, one fiedl parameter slices another....magic
Nice video. I have a suggestion that might make a good piece of discovery work / a video people would appreciate. Paginated reports don't get a lot of love but are incredibly useful. My biggest gripe with them is the inability to set "optional" report filter parameters without the need for separate queries for each. I have 100 parameters my users may need to use "sometimes" to wean them off our older reporting tools but this is what is keeping them out of power bi and I'm not clever enough to have worked out a viable solution... are you?
Right click a filed and select create hierarchy. Once create you can add other fields in order to that hierarchy by again right clicking, add to hierarchy.
Even the underline trick can be done with the new slicer visual....the bookmark ideia is just a good way to make it hard for yourself... I'm sorry but this video is waaay outdated and is missleading for people
This is nice but I somehow feel like your content is getting repetitive and not much exciting. Another workaround technique. With too many options and functions, Power BI is getting slower and slower. Imagine the same technique I need to implement for all 30 visuals in a report. Client doesn't see the performance issue until it's scaled up to large extent. Can you create some videos on optimization of huge power bi report end to end. Including data cleaning, data modeling and data visualisations. Thank you
i started with bookmarks , but now i am using field parameter for this to switch, in my opinion it is a bit easier to maintain
Came to say this. I used this before, but currently, field parameters do it in a second. Why torture yourself. :) However, for people who have a lot of time to deal with the design of reports, this way, you have way more chances to make it look prettier. But most of us don't have that luxury much. :)
i was also thinking the same filed parameters are just 2 clicks away
Field parameter's don't allow you to sort
@@omer1712 True, but there is a trick. You can add custom sorting measure to the vizualization in tooltip field. Then you can sort it regardless of field parameter selection
@@omer1712 you can sort field paramenter, change the index manually in the dax code
You can even add another key, link it to another field parameter (with the mathcing key), and now, one fiedl parameter slices another....magic
Field parameters is the right way to achieve this , I used to follow this sometimes back
Using bookmarks like this feels like I've went back 3 years. Some funky measures and a field parameter would get this done a lot simpler imo.
Any example?
@@Luggruff go check field paramenter, and see for yourself
The underlining thing blew my mind. Totally did not see that coming!
Cool idea with the underline!
Really helpful. Thanks for this.
That's hella slick on the underline trick!
Bookmarks approach would much better to change the type of visual. Honestly, for this use case I would use Field Parameters + New Button Slicer.
Very cool. I'm going to try to use it in one of my visuals
Done something similar to show shadows. Very slick indeed.
Thanks a lot. Even if I learn a little (or a lot) that's a time well invested. Thanks for the underline trick, it was quite simple and cool.
This is so cool!!!
Today I have got the same requirement
I am breaking my head to implement this but your video helps me a lot 😊
Nice video. I have a suggestion that might make a good piece of discovery work / a video people would appreciate. Paginated reports don't get a lot of love but are incredibly useful. My biggest gripe with them is the inability to set "optional" report filter parameters without the need for separate queries for each. I have 100 parameters my users may need to use "sometimes" to wean them off our older reporting tools but this is what is keeping them out of power bi and I'm not clever enough to have worked out a viable solution... are you?
I feel like this would break real fast in a real environment where visuals change all the time
Been doin this underline trick since 2019
Very nice
Could we do the same thing with field parameters?
Any idea how to create categorical hierarchy that he used?
@prasanth1788 if you right click on a field or drag and drop it on another field I believe it creates one
Right click a filed and select create hierarchy. Once create you can add other fields in order to that hierarchy by again right clicking, add to hierarchy.
@@eriknegron1047 thanks buddy this worked.
Even the underline trick can be done with the new slicer visual....the bookmark ideia is just a good way to make it hard for yourself... I'm sorry but this video is waaay outdated and is missleading for people
This is nice but I somehow feel like your content is getting repetitive and not much exciting.
Another workaround technique.
With too many options and functions, Power BI is getting slower and slower.
Imagine the same technique I need to implement for all 30 visuals in a report.
Client doesn't see the performance issue until it's scaled up to large extent.
Can you create some videos on optimization of huge power bi report end to end.
Including data cleaning, data modeling and data visualisations.
Thank you