Power BI Themes with CUSTOM ICONS 🚀 ❤️
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2024
- Join my Power BI Design training here: my.datatraining.io/pages/powe...
In this video I show you how to add custom icons to a theme. This speeds up development, makes icons easy to share with colleagues, and keeps your DAX clean from long img urls.
Enjoy and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
04:43 Using conditional formatting icons
07:38 Embedding custom icons in a Power BI theme
15:00 Using embedded theme icons
17:50 Embedding theme icons using Base64 images
20:02 Improving how the icons show
20:55 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on TH-cam: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAXges/powerbidesigntransformation - วิทยาศาสตร์และเทคโนโลยี
Upcoming Power BI Design Transformation: datatraining.io/powerbidesigntransformation
To quote “Bill and Ted”, Excellent! In an industry full of hacks and wannabes, you consistently share creative and elegant solutions. Nice work.
really nice to hear that!! thanks a lot 🤓💻😊
I love and respect how you include when things go wrong. This is truly the mark of a master.
:p well I don't keep all my mistakes in the videos :p then they would all be over 2 hours lol
I'm astonished how do you know all this things and how you generously presented them to us!
Never knew this was possible, and never would have figured it out without a video like this, thank you! Those company theme files are an incredible idea.
Brilliant, Bas! A huge thank you!!
This one is AWESOME!!!!!! 😁🎉 Thank you!!!
Oh, my God! How professionally creative you are. I used it via SVG, but your idea is much better... Thank you for your professionalism ✌✌ 😀😀
😎👊
@@HowtoPowerBI I sent you a link to my project on Power Bi. I hope you can see it
This is awesome!! Thanks for all the amazing content (cheers from Brazil)
Glad you enjoy it! thx for watching and cheers from germany ;)
Finally!!! I have been looking for an easy way to do it since 2019. Tyvm Bas!
😁 you should have told me!
@@HowtoPowerBI In this instance, I'd like to raise a request regarding the second topic, for which I'm currently without a solution. Is it feasible to develop a Dropdown slicer that incorporates user input for filtering selections? Ideally, it would operate similarly to the basic filtering function found in the side panel.
I know, that filter panel is solving this task. However, filter panel has drawbacks. It looks plain and, more importantly, once minimized, the filter panel does not give user a hint which values (if any) were selected.
Back in 2020 or so, there used to be a working slicer that supported user input in the marketplace. But this visual came from a Chinese developer, was not properly translated and got slashed by Microsoft at some point (for security reasons I believe).
@@alexgry4763 Would turning Search on for a dropdown slicer do the trick?
Whoa… this is fire! Thanks Bas!!!
🎇🧨✨🎉 thanks!!
Awesome! Thanks for sharing this. Appreciate you also covering how things can go wrong.
💻🤓 thx!
beyond godlike, this man !
mind-blowing, thank you for sharing
😁😎👊
You, sir, are a genius!
Naah .. just know a bit of power bi 😄
Love it great little hack!
😎👊
Just yesterday I was annoyed at the limited icon options for conditional formatting, I went the Base64 route like I also had to for my logos but it's still not quite ideal - this is somehow the perfect video, right when I needed it!
glad to hear it helped a bit! thx for watching 😁
Great insights as always. Thank you so very much, Bas!
Some of the PowerBI Theme Generators seem also to be useful for custom Icons. Would you recommend one?
Thank you mate, always valuable. I've created an official company process on this based on the video :)
Fantastic! 🤓💻👊😎
Beautiful.
☺️
OK, I just hit tilt. I was blown away to see your SVG video and now this . This technique is going to be used in EVERYTHING!!!
Your content is ludicrously good. My team follow and learn from you after I showcased your content to them. I probably have more of your innovations and visual techniques in my own models than from any other content developer. Thank you Bas
excellent content Thank you so much
💻🤓 Thanks
this is really very interesting to use json for icons, thanks for sharing this.
thanks for watching!
Awesome, thank you :)
thx for watchn!
You are Super Bas... Thank you very much
☺️☺️☺️
Top Man!
Nice solution. Great to see that even you have the "bang head here" moments :) 💥💥
😅😅😅 got them aaaaalll the time .. but normally I would cut them out of the video lol
Brilliant 👏 👏 👏
💻🤓 thanks!
what I can say !!! we struggles couple of months back searching for icons and sew how beautifully you have described the tricks !!
many many thanks and great work!!
I am surely gonna try this…
Do you have any solution where we can use bar chars in matrix ???
Thanks Bas!!
☺️
Oo that's awesome
😁🎉
Great video as always. I wonder if you could or have done in the past a video that deals with "Bridge Tables" or relationship between two tables that have different granularity. I am struggling a little bit to find out the optimal method to solve my data model when I can't really do one-to-many one direction relationship, it seems like all solutions come back to either many-to-many or a bi-directional filter.
you need dimension tables from where you can set up the relationships to the 2 fact tables .. that way you dont need many to many nor bi directional
Can I use Unicode characters instead of SVG?
I know you can code DAX with Unicodes, but I would like to have them in the conditional formatting menu
I got an error when uploading the file back to PBI. I kept the name for the new objects in lowercase and worked! Thanks!!!
I'd the same lol
Hi Bas, Great fan of your work, Can you make a video on how to set colors dynamically in legend option for a visual in power bi???? Please, As Power bi doesnt provide conditional formatting for Legend option looking for alternatives
hope you would a video on this
hi i just want a question that we there is statement in card top account microsoft and apple and this microsoft and apple are dynamic if i want to highlight microsoft and apple this with different colour from Top account . how we do
Hello Sir,
When to combine ALL Function with Calculate + Filter in Dax together ?
Could you make a video of it please 🙏
Excellent as ever. On 12:26 you mention a video link to more about creating svg images, but I didn't see it magically appear as expected.
Could you tell us again.
oops i forgot .. here you go th-cam.com/video/QOcP5OvSwlI/w-d-xo.html
@@HowtoPowerBI Aha - watched and saved in my useful folder already (it was very good and very helpful)
Do you have any ideas about How to use the matrix table visual in Arabic (right to left) using MS power BI?
Awesome way:)
Is it possible add these changes in the custom font file. Can we combine both in a single json?
yes you can .. just keep in mind that the viewer needs to have the custom font installed on his/her laptop otherwise it defaults to times new roman
Could you please make a Y-shorts video on this as Im unable to find any solution were we can do the custom font & add extra icon in a single json.
Hi, Created power bi dashboard and export it to Live ppt. Is it possible to share live ppt to non pbi users? Because shared ones are saying they can’t see the ppt. Can you please help on this?
Hi, I have a question. How to make the x-axis static in a bar chart. My goal is, when I select a slicer, the x-axis is always displayed
Please upload a fresher power bi project to get a job as data analyst
Hello Bas,
I have a columns like week18, week19, week20, week21, week22, underneath each column I have customer qty and buyer as sub column headers in table1, same way I have columns like week19, week20, week21, week22, week23 underneath each column I have customer qty and buyer as sub column headers in table2 as well, these files I will receive on weekly basis so column headers will keep moving forward to next WeekNo and so on. These files are stored in SharePoint folders. Requirement is that i want to append these tables and prepare a output report which includes those all week columns as single column as "week" And underneath wk-18, wk-19, wk-20, wk-21, wk-22, wk-23 to those corresponding customer qty and buyer values. I am facing challenge in handling week (date) columns as it's weekno keep moving forward and we end up getting to different weekno columns and not sure like which weekno belongs which value. Can you please help me to find a solution for this?
This video will help
th-cam.com/video/VV7fRIkfVts/w-d-xo.html
I struggled to get this to work... Eventually writing "icons" and "description" in lower case rather than capitalised seemed to do it.
that's why i left that error in the video, so that you don't have to go through it 😊
I wish Power BI would just include the possibility of importing an image directly without adjusting the theme similar to what Tableau is providing thank you for sharing the details for what is it like to do it in power bi but that is still too much work for the icons
the equivalent in tableau would be to add the images to "my tableau repository" no? ..
@HowtoPowerBI yes exactly I see the flexibility and professionally the SVG adds, but giving both options will make customization features more accessible to the general users as it requires less time to set up and less coding skills
I had import theme successfully, but can not show in matrix, only image icon but not show out
That means you have a mistake in the svg image code, for example not replacing # with %23 , or missing info before the svg code that powerbi requires.
15:50 your minecraft server is up 😂
?
got the error:
#/icons/Bad must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties)
#/icons/Poor must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties)
#/icons must be array (type; matching schema #/properties/icons/anyOf/1/type)
#/icons must match a schema in anyOf (anyOf; matching schema #/properties/icons/anyOf)
Please guide
it is pointing out that there are not allowed properties.. so my guess is that you've made some typos
@@HowtoPowerBI thanks for quick response. I have verified there that but there is no typos error
@@akashpatil9865 add the schema , it will help you find it -> here is how th-cam.com/video/hvY6SJrq3Ys/w-d-xo.html ... 13:50 (timestamp)
@@HowtoPowerBI i have tried to use svg from svg viewer itself but that is also not working...
@@akashpatil9865 you have Description instead of description ... 😅i even show the error in the vid
Sorry, love the video but I feel obligated to point out that an RG color blind person will not be able to see a difference in those circles. We should always also provide a shape differentiation whenever using Red/Green icons.
Indeed important, but not really the point of this video