Reusing formatting for Power BI reports
ฝัง
- เผยแพร่เมื่อ 6 ก.พ. 2025
- How you can save time when building and maintaining Power BI reports by using strategies to re-use visual formatting.
Article and download: sql.bi/860880?...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...
I have been waiting for a thorough and useful explanation about Themes. Thanks Kurt!
This video is so great that we feel exactly the same emotion again and again, and now Kurt is showing us some good method to finally tackle the 'beast'. Love the final portion of the video! Keep it up, Kurt!
Thank you for helping us enjoy working with Power BI and helping us change our Power BI day-to-day dev journey from an frustrating adventure to an enjoyable one ✅
Once again you are taking reusability and efficiency to the next level! I was not aware of quite some details like using template color names for measures - really powerful timesaver
Thanks for explaining an sharing your template - awesome stuff to build up from! 💪👍
UNUSUALLY emotional and animated Kurt has convinced (threatened) me into planning to invest my time setting up a proper theme file during this holiday break...
Don't work over the holidays! 😉
Thanks for the thoughts! Maintaining a theme file in our GIT repo sounds way better than re-applying formatting changes on each of our reports. Nailed it once again.
Amazing tips!!! I didn't know that you can actually reference theme colours in DAX!!! 🤯
Thank you so much!!!
Fantastic being able to use variable names from theme file in conditional formatting.
Great insights on using measures more effectively for formatting. Thank you!
Great insights! It seems that it's one of the points that bothers Kurt a lot 😁 The content was beneficial, and the explanation was clear, as always! Thank you!
This topic was very much needed. Thanks for the information presented, as always, in a brilliant way! 👍
excellent video, thank you very much. I also found that formatting took me 4-5 times longer than initially thought. This will save time.
Great tips! Many thanks. The end of the video is brilliant 😅
Looks like you did some formatting to your beard too!
Great video again. Creating a theme file is one of the first things I did when I joined my latest employer. It was a great way to impress my new colleagues. But as always, you taught me some new skills with this video too. Thanks!
Wonderful.... it's a time saver 👌
🤣🤣 Great Kurt. I can so relate to the nightmare task of formatting multiple visuals.
Thank you for your time and, as usual, nicely explained and demoed content!. I will most definitely be making use of this from now on. The theme editor in PBI is (as usual) woefully inadequate. It would be nice if you could see the changes while you customise elements and even better if the saved theme file was prefilled with all of the default settings.
Passive aggressive level turned up to 11 - love it! Hopefully you didn't hurt anyone before you got to vent at the gym 🤣
This is excellent! I have been building a theme file and improve how we are using it accross reports and this filled in some missing knowledge. Thank you!!
Great video, huge time saver, many thanks for sharing this😊
Absolutely professionnel !
Brilliant thanks for sharing ♥️
This is great; thank you so much, Kurt. I need a video course with all these nice tips.
Mate! Brilliant! It really me off that the "Conditional Formatting" option of databars does not itself let you use conditional formatting to DYNAMICALLY change things like min/max or colour based on what the user might be filtering on. GRRR!
Love the outtake outrage outburst!
Great information, thank you for sharing :)
Thanks such an amazing demonstration
Very useful and well explained, thank you!
Also, I like your passion for Power BI :)
Thx. We use a somewhat standard json theme, though some bugs. Great tip with the naming inside the json for DAX. Enjoy - new card viz.
Thank you! I find this very usefull
i was using the json file but i didnt know how i could connect it to the conditional formatting settings :)
Absolutely amazing. Huge ROI for design
nice tips, love the ending, we've all been there 😁
Very helpful, thank you.
Another benefit besides saving work: similar design across all your reports, which increases usability and user acceptance.
Wow i learned something new ❤
I like your Videos SQLBI, why not make a video together where you do maybe a Q & A or generally speak from your experience of getting to the level you guys are currently at whether its DAX, SQL, PowerBI or the Data Analysis field in general.
I feel like such topics would also be very interesting to speak about.
the ending was epic.
very nice and helpful
Great video, pitched at an accessible level. Nice calm delivery! I'm not sure whether I can transfer a bunch of conditional measures when the actual columns are different between 2 reports....
Nice video ❤
This is great!
note for the viewers. watch until the end :)
This is genius! Thanks
Kurt, bring your beard back. It was like Jesus was teaching us intricacies of BI in easiest possible way.
The beard is perpetually returning
Very useful thanks for sharing¡¡¡
I had no idea you could define named custom top level colors 🤯
Very timely and great video! I share your frustration as I've spent the last couple of days tweaking visuals formatting. I already use DAX measures for conditional formatting but I didn't know that it could reference theme colors.
I'd be interested to know your thoughts on Deneb. I found LLMs are really good at creating and modifying Deneb visuals since Vega is an established framework and very well documented. Claude's artifact can even show the result in real time!I'm more and more tempted to use it for all my visuals, the level of customization and reusability is a game changer compared to Power BI native visuals. But I wonder if it has an impact on performance.
Kurt covered Deneb (compared to other options) in this article/video: www.sqlbi.com/articles/creating-custom-visuals-in-power-bi-with-dax/
OMG! It will save tons of time......
Awesome! Thank you
Useful (as always). Any risks of powerbi's failing because of themes used ?
No, themes will fail to apply if they fail schema validation. However, it will not validate whether certain properties are valid or appropriate, like invalid image definitions (for page backgrounds) or poorly-chosen fonts (i.e. custom fonts) or colors (i.e. over-use of red).
great video sir. What mic are you using?
Kurt uses the same mic as Alberto, who described it here: www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/
Your cat skeered me!! Great presentation, though.
Hahahahha, the ending is epic.
Thanks 🥰
Thank you Kurt - this is amazing.
How about Conditional Formatting on variance percentage data bars on an Income Statement - increase in Revenue lines in Green or good and increase in Expense line items in red or bad and decrease in Expense line items in green or good Thank you in advance
23:48 love the Jonathan Pie like outtake :} eg Jonathan Pie: 'It's 50 Shades of Beige.' th-cam.com/video/ghr2M8mh8MA/w-d-xo.html
May I know which software you use to screen record and video editor
The end rant. Yes. The amount of time I’ve spent on formatting the new cards. The limit does not exist.
Hey Kurt, off topic but which microphone are you using here?
Kurt uses the same mic as Alberto, who described it here: www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/
I am struggling with columns width for my matrix (i have a report with different pages, and each page has a different matrix) the width of the columns must be the same for all the columns in all matrix.
I think using json file theme should be the solution. Don't know
Someone have a solution ?
On my personal channel i describe how to do this by modifying the layout.json or .pbir when you save a report as a .pbip file.
Q: With the theme schema, do you know if it allows custom named colours, e.g "brandColour": "#0172be",
No unfortunately not. There is schema validation that only allows certain properties.