Thanks for this informative tutorial. I've been following along and everything works perfectly, except for the part at 26:26 mark. My horizontal slicer is taking up all the visual space when one value is selected, unlike what happens in your video. Any suggestions on how to fix that please? Thanks again for the helpful tutorial.
Amazing tutorial, your abilities and attention to details are unmatched. Your ability to bridge the gap between nerdy sophisticated stuff and make it human and beautiful reminds me of Steve Jobs.
This is very useful in terms of UX it brings transparency on what´s being filtered and avoid confusions at all, congrats as always you come with five stars content
hi there! thank u for this amazing tutorial. my dashboard at work needed this exact structure for its slicers. however i have a question; could this be applied for say if i have a slicer that takes in 2 levels? Groups level and then detailed level?
@@yourownkpi I loved it. It's a different way of creating a great dashboard. I watched almost all of your videos while I was commuting to work and I got many insights, moreover, it is a good way to improve my listening as I am an ESL
Amazing Technique. Can you also give us tutorial on how to copy and paste this bookmark ( slicer panel) in another sheet? or how we save this slicer panel as template then we can use in other reports too.
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.
Youre welcome! You need to make sure that the layer order is maintained. Selected the shape, go to Visualization panel/General/Properties/Advanced options/ toggle on Maintain layer order. This way the shape stays behind the slicers even when you click on it.
Thanks for your amazing tutorials, Mr. Szabó. I followed the link to the pbix file of this video that you shared on Google Drive and it appears that the file is not the one for this video. Would you mind checking?
Youre welcome! It is the correct file, you only have to build the visuals :D Tomorrow I upload part 4 and there the upload file will already have the finished part 3 version.
@@yourownkpi Thank you! Would it be convenient to write to you by e-mail? We liked your channel and would like to offer you one of our products for review. Or even invite you to participate in our affiliate program.
Zsolti may I suggest something for your next video? 🙈🙈🙈🙈 Can you please teach us how to create a multilanguage Dashboard in Power BI that enables the user to select a Slicer and change the visuals, table values and displayed names dynamically? I have been looking for something on Google, and RUclips and so far I couldn't find anything, something similar to a webpage that you click in a flag and then everything changes. Please, can you help me with this?
Hm thats a good idea. Currently I'm working on other videos but I put this to my video ideas. What I can think of out of my head is to create conditionally formatted text for every visual, but maybe there is a better way 🤔
@@yourownkpi For the titles and Legends it works, but the problem is the description in the Axis and values in the Tables. I think can't explain it properly so, I created this link to the database example and what I'm trying to see. I would appreciate it if you could help me with this crazy idea and record a video for one of your fans in the future, no rush, no pressure, no worries. docs.google.com/spreadsheets/d/1qr5-fFKtsEBhSn35saRGjeSQXwkvtRAu/edit?usp=drive_link&ouid=104255408439262874509&rtpof=true&sd=true
I see what you mean. That could be an interesting video indeed :D What I'm thinking about is either creating a separate id column for all the languages or creating one big mesh dimension table with unpivoted columns. I don't know if these work, but Im also curious now :) Could I use your sample file if I made a video on this?
@yourownkpi Hi Zsolt, yes, for sure you can use the file. I had an idea similar to yours: create a table with all the data and avoid duplicates in the dimensions by filtering the language in Power Query and linking them with parameters. The problem is that users cannot access parameters in the power bi service once it is published. So, I feel like I'm walking in circles. Now, I hope you can do some magic like 1..2...3 kaboom! 🤓🙈
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Thanks for this informative tutorial. I've been following along and everything works perfectly, except for the part at 26:26 mark. My horizontal slicer is taking up all the visual space when one value is selected, unlike what happens in your video. Any suggestions on how to fix that please? Thanks again for the helpful tutorial.
Amazing tutorial, your abilities and attention to details are unmatched.
Your ability to bridge the gap between nerdy sophisticated stuff and make it human and beautiful reminds me of Steve Jobs.
Thats such a nice feedback :D thank you, very much appreciated
Or no fluff, just useful ...
This is very useful in terms of UX it brings transparency on what´s being filtered and avoid confusions at all, congrats as always you come with five stars content
Thanks very much appreciated :)
really awesome tutorial brother, straightforward enough to follow along with
Glad to hear that!
Wow, that's some next level Power BI.
Thanks for sharing your knowledge!
hi there! thank u for this amazing tutorial. my dashboard at work needed this exact structure for its slicers. however i have a question; could this be applied for say if i have a slicer that takes in 2 levels? Groups level and then detailed level?
Nice solution, nicely explained with some great alternatives 👍
thanks for the feedback :)
Can’t wait to see the part 4
It's coming next week :)
The video everyone's been waiting for is finally here! ❤❤❤
I hope you liked it haha
@@yourownkpi I loved it. It's a different way of creating a great dashboard. I watched almost all of your videos while I was commuting to work and I got many insights, moreover, it is a good way to improve my listening as I am an ESL
Thats great, although my English is not the best :D
wow Just wow.... This is amazing.
Amazing Technique. Can you also give us tutorial on how to copy and paste this bookmark ( slicer panel) in another sheet? or how we save this slicer panel as template then we can use in other reports too.
Im glad you liked it :) As far as I know it's not possible to copy bookmarks in Power BI. You have to create them manually on each page.
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.
Youre welcome! You need to make sure that the layer order is maintained. Selected the shape, go to Visualization panel/General/Properties/Advanced options/ toggle on Maintain layer order. This way the shape stays behind the slicers even when you click on it.
@@yourownkpi Thank you !
Thanks for your amazing tutorials, Mr. Szabó. I followed the link to the pbix file of this video that you shared on Google Drive and it appears that the file is not the one for this video. Would you mind checking?
Youre welcome! It is the correct file, you only have to build the visuals :D Tomorrow I upload part 4 and there the upload file will already have the finished part 3 version.
Hello, Zsolti! How can I contact with you?
hey, you can contact me on linkedin :)
www.linkedin.com/in/zsolt-szabo-bln/
@@yourownkpi Thank you! Would it be convenient to write to you by e-mail? We liked your channel and would like to offer you one of our products for review. Or even invite you to participate in our affiliate program.
I prefer contact over linkedin or instagram :) I don't want to give out my email in public comments haha
Zsolti may I suggest something for your next video? 🙈🙈🙈🙈
Can you please teach us how to create a multilanguage Dashboard in Power BI that enables the user to select a Slicer and change the visuals, table values and displayed names dynamically?
I have been looking for something on Google, and RUclips and so far I couldn't find anything, something similar to a webpage that you click in a flag and then everything changes. Please, can you help me with this?
Hm thats a good idea. Currently I'm working on other videos but I put this to my video ideas. What I can think of out of my head is to create conditionally formatted text for every visual, but maybe there is a better way 🤔
@@yourownkpi For the titles and Legends it works, but the problem is the description in the Axis and values in the Tables.
I think can't explain it properly so, I created this link to the database example and what I'm trying to see. I would appreciate it if you could help me with this crazy idea and record a video for one of your fans in the future, no rush, no pressure, no worries.
docs.google.com/spreadsheets/d/1qr5-fFKtsEBhSn35saRGjeSQXwkvtRAu/edit?usp=drive_link&ouid=104255408439262874509&rtpof=true&sd=true
I see what you mean. That could be an interesting video indeed :D
What I'm thinking about is either creating a separate id column for all the languages or creating one big mesh dimension table with unpivoted columns. I don't know if these work, but Im also curious now :)
Could I use your sample file if I made a video on this?
@yourownkpi Hi Zsolt, yes, for sure you can use the file.
I had an idea similar to yours: create a table with all the data and avoid duplicates in the dimensions by filtering the language in Power Query and linking them with parameters. The problem is that users cannot access parameters in the power bi service once it is published. So, I feel like I'm walking in circles. Now, I hope you can do some magic like 1..2...3 kaboom! 🤓🙈
I will see what can I do :D thanks!