Deep dive on how to create Power BI themes with a JSON file

[@liamrigby899]

Thanks so much, I have was struggling to understand how to build a JSON theme in bi with microsoft's documentation. I have managed to pick it up within a few hours after following both your guides also love that I was able to change the colour of the goal on a kpi visual which was annoyingly missed out in BI formatting section.

[@CurbalEN]

Yey!!! 🎉🎉🎉 That makes all my efforts worth it! Hope you are making gorgeous presentations now 🌼 /Ruth

[@kaustubhbandewar6844]

Hi Ruth, Thanks for this. But I am not able to download JSON from the website. I also registered the membership. Is it Chargeable ?

[@austinpeterson9595]

Is there a way to set your column *values* to centered like you can with the column headers?

[@triparnaray]

Hi where can I get the source/power bi file to get the JSON details you are referring at to be used in a JSON file in this video. Please share the link to download.

[@Michella1393]

Hi, thanks for this amazing tutorial! I am trying to access the example file from the download page but it does not work. Any suggestions?

[@raviissrani__0324]

Hello Ruth! The video link you shared (Guide to create JSON file) where we can find names which we have to use while creating JSON file is not opening. Can you please reshare it

[@MandleDan]

Hello Ruth! I'm new to Power BI, thinking of switching over after spending years with Tableau. Your videos are really helpful! Wondering where folks might be able to access Theme "tester" template you click over to a few times in this video (for instance, at 17:36). Is that something you could share? (Apologies if it's been done already and I've missed that!)

[@CurbalEN]

Hi Dan! Yes, you access that on this link: curbal.com/donwload-center It requires membership, but it is free to join and I send around 2 newsletter a year. Just to warn you, the file I share is my personal file so it is messy ( but it works) Welcome to the power bi community!!! Great to have you with us :) /Ruth

[@CheRFlowers]

the dashboard created in this video uses back and forward buttons to make the interface a bit more specific and dynamic. How did you add those navigation buttons to make the filtering process multi-step?

[@CurbalEN]

Hi Che, You mean drillthrough?: Deep dive on Power BI drillthrough functionality kzbin.info/www/bejne/bWPFlnqVi62onLc /Ruth

[@CheRFlowers]

Yep, that's it! Thank you. As a follow up - my goal is to create a dashboard a user can drill-through to create their own custom list. Then I would like them to submit that custom created list to me. Is there any way to configure a submission of sorts? Or perhaps a button that creates an email with the list attached?

[@CurbalEN]

Kind of, here is a way to do it: kzbin.info/www/bejne/Z2qWk2qKlNVma68 Or with excel: kzbin.info/www/bejne/gpDEnHyKoZmCjNk /Ruth

[@lassejrgensen3947]

Hi Curbal/Ruth Is it not possible to simply configure the overall title property of a visual in the JSON file? I tried several times but it doesnt seem to work when i load it into the desktop. I can configure the axis titles but not the overall visual title. Thats strange isnt it? If you know how can you please advise.

[@CurbalEN]

It is not possible I am afraid... not yet at least! /Ruth

[@janmaarten6250]

Try using "title" as cardname. I managed to edit the fontsize of the title of a clustered column chart in this way.

[@peggysuemarlin5131]

After some trial and error, I've found this format to work for "title" cards on Matrix and Multi-Row Card visuals. Haven't tried on any other visuals yet. "title": [{ "show": true, "fontColor": {"solid": { "color": "#FFF200" } }, "background": {"solid": { "color": "#000000" } }, "fontSize": 12}]

[@CurbalEN]

Thanks for sharing!! :) /Ruth

[@olliehosking123]

Hi, with the data colours can you apply more then one colour to a bar chart, and have a treemap display other colours? So if someone is looking at the dashobard they dont think the bar chart is showing the same infro as the treemap.

[@mariovargascareaga]

Which version of power bi do you have? I cant see the option switch theme

[@CurbalEN]

You need to activate it under Option > preview features ( or something like it, I am pulling from memory) /Ruth

[@mariovargascareaga]

It's working thnx

[@CurbalEN]

Perfect! Enjoy the weekend now :) /Ruth

[@satishganai3942]

DataColors array at the top is common to all charts. If I want to apply different data colors to different chart, how to do that?

[@RajanieshKaushikk]

I am unable to find the link for the file shown in the video

[@CurbalEN]

Link to my JSON template prototype and live power bi report: curbal.com/blog/power-bi-template-to-create-report-themes-with-the-json-template /Ruth

[@adrcl]

i liked a lot the way you explained!! thanks a lot

[@CurbalEN]

Thanks!! Glad it was useful! /Ruth

[@christopherhastings2142]

This is a great explanation! I marked it for future reference.

[@CurbalEN]

Messy uh? /Ruth

[@frankgovers8420]

A big step back in time, like basic or dos. i’ll hope that someone will create a kind of normal gui to create this. Like the theme builder for a pbix file

[@CurbalEN]

Agreed! I don’t have the knowledge to create a better tool, but hopefully somebody else does and will... /Ruth

[@darrannorman6185]

This might help powerbi.tips/tools/report-theme-generator-v3/

[@CurbalEN]

Yes! Mike’s tool! I forgot about it, thanks :) /Ruth

[@utkarshasane8599]

Hey can you give your own property name for any visual? If so how?

[@CurbalEN]

I don’t think you can do that , you need to use the names provided by Microsoft. /Ruth

[@11vitoroliveira]

Hi Curbal, Can I add a background image with the Power BI Reports?

[@CurbalEN]

Yes, but you can’t do that with the JSOn template. /Ruth

[@RajanieshKaushikk]

I have a small suggestion to include the exact file name from the download center which you are using to showcase.

[@CurbalEN]

Yes, I am giving it numbers, but the early ones are a bit of a mess...sorry. /Ruth

[@luigimurci7653]

Hi, Thanks for your amazing video, very helpfully. Do you know if it is possible to have different themes for every sheet in the same power bi file?

[@CurbalEN]

Not yet I am afraid... /Ruth

[@Gunterlund583]

Curbal does this still work, its not drilling through

[@CurbalEN]

I used it a week ago and was still working. Maybe it doesn’t work with the new update? /Ruth

[@Golden_Tortoise]

Thank you so much! This is very helpful!

[@Golden_Tortoise]

Suggestion: Add a card (on the curbal tool) for general setting (key terms/JSON terms), not just for specific visuals. Example: Fond Size [JSON name] ... Hopefully my suggestion is clear Thank you again!

[@CurbalEN]

Amazing little trick right? :) /Ruth

[@Golden_Tortoise]

This video needs to be more viral :)

[@CurbalEN]

😂 Agreed!

[@CurbalEN]

Hi! Your comment got spammed... I will do, thanks for the suggestion:) /Ruth

[@Cokezero2610]

Hi all, Does anyone know if there is a way to turn off gridlines or change the chart title from the JSON file?

[@CurbalEN]

Nothing happened when you made the changes? /Ruth

[@janfranck5346]

Hi Marko. I was looking for exactly that but Microsoft says you can not change title etc. (non-tile specific things) from JSON. Maybe it will come later.

[@airbornetroops1]

Hi This is really helpful, Thanks a lott for the video!! 😊

[@CurbalEN]

And thanks for watching :) /Ruth

[@RenataCoAz]

Where can I find the template?

[@CurbalEN]

At Curbal.com download center and then membership downloads:) /Ruth

[@sanskritisingh1242]

Hi This is really helpful, Thanks a lott for the video!! 😊 Could you please tell us the link that is used to search the JSON visual Name? (@03.37 mins)

[@CurbalEN]

Hi, Here you have it: curbal.com/blog/power-bi-template-to-create-report-themes-with-the-json-template /Ruth

[@saseendrareddy1393]

Hi thaks for the video it's really helpful.. Do we have jsone code for fixed page size for all pages (I mean like we need to have fixed size of page so that when we add a page in power bi desktop we no more need change every time. That should be fixed for all pages we We able to change fixed background and out space for all page's but I need fixed page size too for all pages) Pls let me if any one have solution Thanks in advance...

[@christophermueller3373]

Has anyone figured out how to do the rounded corners on the border?

[@kumarvg5383]

Hi, Is that possible to get the bookmarks option as a customized Link....

[@CurbalEN]

Hi, which bookmark option? /Ruth

[@kumarvg5383]

docs.microsoft.com/en-us/power-bi/desktop-bookmarks

[@CurbalEN]

Hi! I still don’t understand your question, can you explain again? /Ruth

[@izabelaedmunds9746]

At the moment no, but you can vote for this to be implemented by Microsoft ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31788253-personalized-bookmarks

[@CurbalEN]

Thanks Izabela :) /Ruth

[@tubeyouJC88]

This is Great! Thanks

[@luise6124]

Thank you so much!!

[@marounsader318]

its there anyway to know how to make layouts too and the way behind it just like the last update PBI team use a template from powerbi.tips temp[late and i really dont know how they managed to create the layouts that way

[@CurbalEN]

Hi, let me check and I will let you know :) /Ruth

[@CurbalEN]

When you say layout, you mean the background “boxes” ? /Ruth

[@marounsader318]

Yes yes i thought they were colore but when i downloaded the template they were fixed like you put your graphs on them

[@marounsader318]

Wow thanks alot for taking my request in consideration ive been looking for someone to help me knowing what are these boxes

[@CurbalEN]

You just create your report and then save it as a template and you are done :) Here is how to create a template, kind of... m.kzbin.info/www/bejne/eKaacq2LZ9qbj68 /Ruth

[@MichaelRygaard]

you get into some really great stuff - but to be honest, you are messing around what you want to do 70% of the time - and fast scrolling up and down pages so it is impossible to see what you have write in other examples suggestions 1) make a manuscript - what do you want to explain and in what order 2) do not show 500 lines of code and then change in the middle, show 20 or 30 lines of code, and then at the end show the full

[@CurbalEN]

Thanks for the feedback!