If you are interested in taking your Power BI Design Skills to the Next Level check out my 4 weeks program: my.datatraining.io/pages/powerbidesigntransformation
Hello! Greetings from Rio de Janeiro in Brazil! I've been learning for 6 months with your video contents about power BI and recommending it for other people in my neighborhood. Thanks for the content and great success!
As usual, your set skill is endless! I spend countless hours watching and practicing with your videos. I wish I had enough dashboards to develop to incorporate 1/4 of your awesome work!!!!
Um. I wish I could give this video like 5 likes, one for each part. Mind blown. Hopefully Microsoft improves the tools available for the slicers without these workarounds, but in the meantime these are great, especially the tooltip idea towards the end.
:) ah thats nice! Indeed I still dont get how the selected value needs to always be black, even page and bookmark navigation can have different colors on selected state…
Another fantastic (as always) tip! Your videos are eagerly awaited for the next episode of your favorite TV series. I am sure I will apply your tricks to my desktops.
Thanks for another brilliant video, Bas! Here is a challenge for you: how to create a custom legend that fits on page if there are a large number of categories? Instead of having to click to show the rest of the hidden legend. This would be very useful if the report is shared as a PDF or on a big screen where the user cannot click to see the rest of the legend. Thank you!!
Thank you for a great video. Slicers is always one of those things I struggle with visually on reports. Always a challenge to not make them just look bland and dull. This video helped a lot in terms of creative ideas.
Great video, as always - and the first seconds speak from my heart! A tip for the disconnected table: create one with VALUES. When another category will be implemented, you don't have to maintain the manual input. Works just as fine.
I think if they could somehow integrate the formatting options already available for bookmark/page navigator, it would already be a huge improvement but I won't keep my fingers crossed for that - it feels like native visual options have been neglected for a reason
@@HowtoPowerBI A little issue though, in "vertical slicer with custom check boxes" when I click the slicer twice, its own check boxes appear and custom check boxes go into background in PBI Desktop. Is that expected?
Brilliant Idea Bro, Totally helpful video bro🥰, just waiting for all these to be provided as part of conditional formatting by Microsoft so that it saves a lot of time and adds more value to the tool
Thank you, for the video. Question: based on this example, what if I only want see as options: Animal Health, Pharma, Vaccines and take away/delete: Business Services and Eye Care
Great tricks over there There are some problems thought 1. The technique might not work well when a new item/department is added to the data later, at least for the alignment part 2. One needs many non-conected tables, one for each slicer I just hope Microsoft will hire you for one month to fix this issue and come back to us 😅
You could create the disconnected tables in Power Query by simply duplicating the DIM table and just choosing the column/s you need. That way it would stay current when the departments change.
Always amazed at how you can use the limited tools available to come up with some nice looking solutions. No chiclet slicer love though? Would be interested to see what you could do with it.
This video is excellent master! Thank you for sharing your knowledge and experience with the community. Can I ask you a question? I have a statement with a list of payments, each movement is associated to a document number, the problem is that the payments can be cancelled N amount of times and reapplied, either to the same doc or to another one. I would like to use Power Query to keep only the last odd (non) occurrence of the payments, but if the number of payments is even, discard them all. That is, if doc 1 had 1 payment, 1 cancellation and 1 payment again, only keep the third transaction, but if doc 2 had a payment and it was cancelled, but it was not paid again, discard all the payments of doc 2. Do you think you could help me? Thanks in advance for your time.
finely i got how to change my slicer into horizontal. i got stuck because my slicer was in hierarchy so the slicer setting does not open for orientation options
Hi sir there is challenging task from my client on the on new, old, recovers and lost customer...sir i can provide the data for u to prepare...the viedo
I’ve got a challenge?!…I need help with creating a MILEAGE report with 3 vehicles. I need to create Average of Miles per WEEK,MONTH, & YEAR using a Date Table. I haven’t been able to find a good function to use in DAX. Need Help 😫😤😂
When generating the department disc table, would it not make sense to do it from Power Query based on the actual dimension to make sure we do not miss new values? Irrespective of this, your videos are amazing!!
Have a look at the latest video this maybe helpful here The ULTIMATE Slicer Panel in Power BI ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QaOG42ic2wI.html
Waiting for your reply.... I subscribed immediately after seeing one of your videos and couldnt stop referring your tips post that - 😎. I have a big question, if I get the answer I will feel lucky ??????? How to avoid the ADDITIONAL SPACES on the slicer box when we are showing it as a button ?????, It is really annoying when we have multiple slicer. Any tips on this will be a great help.... ?????????❓