This is the best filter pane video I've ever seen on TH-cam. I always felt Power BI is really lacking proper filter options for end users. Your solution is everything I wanted it to be.
Thanks, that's amazing to read :D Yeah Power BI is primarly not a design tool and it has a lot of limitations. But I think it's catching up nicely and they keep adding new features.
you are by far my favorite powerbi developer right now, you have clean easy code and good minimalistic aesthetic with good color pallets hard to find people that have that all combined.
First of all thank you for your content which is very helpful. I may have missed someting tho because when I am using my app in power BI, I sometime click in the shape of the panel instead of the slicer and panel then come in front en hide the slicers. Do you have any idea on how to fix this ? Thanks again.
Great work. You really do your best with the dashboard UX. I wanted to ask did you use a custom visualization for the table? I tried my best with the tables in PowerBI but the still look rigid as heck. Do you have any tricks up your sleeve?
First of all, thank you for this video. I have a question. If we don't want to show the filters applied with "Filters on all pages", is it possible to only display the filters applied through the slicer on the dashboard?
This is really great and I'm new to Power BI, but trying to find my way. One question I have, I cannot get this filter correctly set if I'm using DATE, any solution/ idea for this
Hi, this is very insightful, thanks a lot. Quick question, do I have to repeat the whole filter creation process on every page/tab I have? I tried copying and pasting but it takes me back to page 1 and filters only the data on that page. How can I solve this issue?
Hello, I like this video alot , but I have one question if I make a filter pane and filter the options and if i Have a power APP tool so will the filters remain unchanged ?
Awesome filter man!! I noticed when I select a single column value in a table visual the counter is activated and it shows a count of 3, and in some other visual like pie chart, it would show count of 2. Any solution to this?
Thanks! Thats a good point. What I can think of is to disable the interaction between the visuals in which slicer data is used. In the example it would be necessary to disable the interaction from the two column charts in the direction of both the filter counter and the button itself
hi. recent subscriber here. Question, at 8:07, how did you pick up and copy the blue color? I checked the Power BI documentation, and I can't seem to find the keyboard shortcut for that. TIA!
@@yourownkpi Ha ha! I thought you were using a color picker since I could not find the keyboard shortcut. Nevertheless, still an amazing tutorial, learned. a lot. Thanks!
I also use a color picker quite often. There is a cool one in the PowerToys bundle from Microsoft and you can pick any color from the screen. Its also free :)
I am looking forward for part 3, 4, 5 and the other new videos you will make. May I suggest something? in your example, the result for the tooltip does not appear in alphabetical order, therefore I added this and I am sharing in case you'd like to use it. CONCATENATEX(Filter_Table,[Value] -- [Value] é o nome default da coluna a tabela virtual , "," -- Separator (optional) ,[Value] -- Sorting expression (optional) ,ASC) -- Sorting direction (optional) --------------------------------------------------------------------------------------------------------------- and before I forget: This video is incridible.
Thanks for the suggestion. That's also a good option. In my case I wanted to sort the slicer names in the same order as they are sorted in the filter panel. And before I forget thanks again :D
you are turning a raw data guy to someone that can build appealing dashboards. Thank you very much!
You elevated the dashboard to a new level. This is now my favorite Power BI channel.
Wow thats awesome :D
You and Bas are truly the master in Dashboard Design in PowerBI, this is just top notch content!!!
That's really motivating, thank you 😊
I also just watch him and Bas for inspiration.
You are literally a data and UX wizard.
What an excellent job, congratulations!!
Wow thanks :D I appreciate it
This is the best filter pane video I've ever seen on TH-cam. I always felt Power BI is really lacking proper filter options for end users. Your solution is everything I wanted it to be.
Thanks, that's amazing to read :D Yeah Power BI is primarly not a design tool and it has a lot of limitations. But I think it's catching up nicely and they keep adding new features.
This may be the best filter pane on TH-cam, great job!
Ah :D I really appreciate it!
you are by far my favorite powerbi developer right now, you have clean easy code and good minimalistic aesthetic with good color pallets hard to find people that have that all combined.
Wow I really appreciate it :D
Amazing contents. Cheers mate!
Thank you brother, its really a very knowledgable session, hats off!!
Always inspired by your work Zsolt, thank you so much for sharing.
Thats great to hear and youre welcome :)
Great work on this! Applied this logic to one of my key dashboards. Bravo!
thanks amd Im glad it helped :)
Just brilliant. Thanks for taking the time to share. 💥💥👍👍
Thanks haha, Im happy to share it
this helped my dashboard look so neat and tidy, thank you very much!
Glad it helped!
Great :) congratulations!!
This is amazing, I can't wait to put it in practice. Thank you for the knowledge bit :)
i learned a lot. as a new power bi user. thanks
Youre welcome!
Great work. Thank you
Glad you liked it!
Awesome content! Can't wait to apply this number feature
Thanks! Im glad it was helpful :)
just wanted to say that your videos are awesome!
Thanks! very much appreciated :)
CTRL + D, powerful!
💪💪
Waiting for next part video
Upload fast ❤
I try my best :)
I love your designs ❤
Amazing video as always mate!!!! thank you!
Glad you enjoyed it :)
you make my day bro, incedible 👏👏👏
Happy to hear that :D
Thank you so much! Great🙏
Thanks for watching :)
Hey, this is great stuff thanks. FYI when you say "height" it is pronounced like "hi-t" not "hey-t" ❤
Oh thanks haha. I learned it once badly and saying it that way ever since 😩 I hope not to forget
Good Job. Can't wait for part2. The filter bar will be interactive?
Thanks. There will be a tooltip in it showing the selected values for the active filters.
Was looking for this thank you Zsolt....
Youre welcme :)
The best, great job!
Thanks a lot!
Awesome stuff
Amazing!
First of all thank you for your content which is very helpful. I may have missed someting tho because when I am using my app in power BI, I sometime click in the shape of the panel instead of the slicer and panel then come in front en hide the slicers. Do you have any idea on how to fix this ? Thanks again.
Very interesting
Great work. You really do your best with the dashboard UX.
I wanted to ask did you use a custom visualization for the table?
I tried my best with the tables in PowerBI but the still look rigid as heck. Do you have any tricks up your sleeve?
Thanks :) No it's the native table and I used a shape for the header background. You can check out how it's been built in the download file
First of all, thank you for this video. I have a question. If we don't want to show the filters applied with "Filters on all pages", is it possible to only display the filters applied through the slicer on the dashboard?
Amzing
This is really great and I'm new to Power BI, but trying to find my way. One question I have, I cannot get this filter correctly set if I'm using DATE, any solution/ idea for this
Great to hear :) What doesnt work correctly exatly?
Hi, this is very insightful, thanks a lot. Quick question, do I have to repeat the whole filter creation process on every page/tab I have? I tried copying and pasting but it takes me back to page 1 and filters only the data on that page. How can I solve this issue?
Youre welcome :) Yes you have to set up the bookmarks on each page individually
Hello, I like this video alot , but I have one question if I make a filter pane and filter the options and if i Have a power APP tool so will the filters remain unchanged ?
Hey thanks :) I can't really tell you, I'm not familair with the Power Apps
Awesome filter man!! I noticed when I select a single column value in a table visual the counter is activated and it shows a count of 3, and in some other visual like pie chart, it would show count of 2. Any solution to this?
Thanks! Thats a good point. What I can think of is to disable the interaction between the visuals in which slicer data is used. In the example it would be necessary to disable the interaction from the two column charts in the direction of both the filter counter and the button itself
Great content - thanks!
thanks for watching :)
hi. recent subscriber here. Question, at 8:07, how did you pick up and copy the blue color? I checked the Power BI documentation, and I can't seem to find the keyboard shortcut for that. TIA!
Welcome to the channel 🤗 I just had it somewhere saved and copied it with Ctrl+C Ctrl+V haha
@@yourownkpi Ha ha! I thought you were using a color picker since I could not find the keyboard shortcut. Nevertheless, still an amazing tutorial, learned. a lot. Thanks!
I also use a color picker quite often. There is a cool one in the PowerToys bundle from Microsoft and you can pick any color from the screen. Its also free :)
I am looking forward for part 3, 4, 5 and the other new videos you will make. May I suggest something? in your example, the result for the tooltip does not appear in alphabetical order, therefore I added this and I am sharing in case you'd like to use it.
CONCATENATEX(Filter_Table,[Value] -- [Value] é o nome default da coluna a tabela virtual
, "," -- Separator (optional)
,[Value] -- Sorting expression (optional)
,ASC) -- Sorting direction (optional)
---------------------------------------------------------------------------------------------------------------
and before I forget: This video is incridible.
Thanks for the suggestion. That's also a good option. In my case I wanted to sort the slicer names in the same order as they are sorted in the filter panel. And before I forget thanks again :D