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.
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!
Note, if you are using Dark Mode and black icons (or light mode and white icons), you will not be able to see the icon in the conditional formatting icon selection screen as the background colour will be the same colour as the icon (e.g. black icon on black background).
Thx for the ideas. Do you by any chance have additional videos talking about Themes? I image there are tons of things you can do with it and save tons of hours to rebuild between different reports.
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
@@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).
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?
i tried creating customize icons but it is not working for m giving error #/icons/Unsatisfactory must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties) #/icons/Average must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties) #/icons/Satisfactory must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties) #/icons/Compliant 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). how to resolve this
it says you got properties that are not in the schema.. so probably typo or big vs small caps (case sensitive) problem .. or simply a mistake in the image code
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 ???
When I add the svg code to the new slicer of power bi no image is shown. It works with the matrix visual but not with the new slicer. Do you have a solution 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.
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.
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
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?
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
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?
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
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
@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
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.
![[LIVE] : ONE ลุมพินี 91 | คู่เอก "คมอาวุธ vs อเล็กเซย์"](http://i.ytimg.com/vi/V0RkEfYFsgM/mqdefault.jpg)
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
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.
This is by far the BEST tutorial on this subject. Thanks !!!
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
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 😁
This is a fantastic tutorial. Thank you
Glad you enjoyed it! thx!!
I'm astonished how do you know all this things and how you generously presented them to us!
Note, if you are using Dark Mode and black icons (or light mode and white icons), you will not be able to see the icon in the conditional formatting icon selection screen as the background colour will be the same colour as the icon (e.g. black icon on black background).
Thx for the ideas. Do you by any chance have additional videos talking about Themes?
I image there are tons of things you can do with it and save tons of hours to rebuild between different reports.
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
Hi! Please share if there is a way to add alt text to custom icons.
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?
You, sir, are a genius!
Naah .. just know a bit of power bi 😄
Awesome! Thanks for sharing this. Appreciate you also covering how things can go wrong.
💻🤓 thx!
This is awesome!! Thanks for all the amazing content (cheers from Brazil)
Glad you enjoy it! thx for watching and cheers from germany ;)
Brilliant, Bas! A huge thank you!!
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! 🤓💻👊😎
i tried creating customize icons but it is not working for m giving error
#/icons/Unsatisfactory must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties)
#/icons/Average must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties)
#/icons/Satisfactory must NOT have additional properties (additionalProperties; matching schema #/definitions/themeIcon/additionalProperties)
#/icons/Compliant 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). how to resolve this
it says you got properties that are not in the schema.. so probably typo or big vs small caps (case sensitive) problem .. or simply a mistake in the image code
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 ???
When I add the svg code to the new slicer of power bi no image is shown. It works with the matrix visual but not with the new slicer. Do you have a solution please?
this is really very interesting to use json for icons, thanks for sharing this.
thanks for watching!
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)
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
This one is AWESOME!!!!!! 😁🎉 Thank you!!!
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
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
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
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
Whoa… this is fire! Thanks Bas!!!
🎇🧨✨🎉 thanks!!
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
Do you have any ideas about How to use the matrix table visual in Arabic (right to left) using MS power BI?
Hello Sir,
When to combine ALL Function with Calculate + Filter in Dax together ?
Could you make a video of it please 🙏
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?
mind-blowing, thank you for sharing
😁😎👊
excellent content Thank you so much
💻🤓 Thanks
Beautiful.
☺️
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.
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.
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 😊
beyond godlike, this man !
You are Super Bas... Thank you very much
☺️☺️☺️
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
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
Awesome, thank you :)
thx for watchn!
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
Love it great little hack!
😎👊
Thanks Bas!!
☺️
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
Oo that's awesome
😁🎉
Brilliant 👏 👏 👏
💻🤓 thanks!
Please upload a fresher power bi project to get a job as data analyst
Top Man!
15:50 your minecraft server is up 😂
?
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