Advanced Power BI Project • End-to-End • ChatGPT • Custom Visuals

[@ivannavarrete4111]

I had the same problem with the heatmap but I can fix it just changing one option (Render option) from SVG to Canvas. I folllow the steps below: 1. In the visual, click the dots in the top right of the visual to edit the Deneb options. 2. I created the new specification using the option VEGA LITE. 3. I selected the option "Create." 4. I copied and pasted the code from Stack Overflow. 5. I clicked on "APPLY CHANGES." 6. I changed the name on line 41 from "KPI" to "Track." 7. I clicked on "APPLY CHANGES" again. 8. In my version of Deneb Visual, I have an option called "SETTINGS." In this section, we can change the RENDER MODE. What I did here is change the SVG mode to CANVAS mode, and that's it; the visual works fine. 9. Click "APPLY CHANGES." NOTE: I'm using an STAND ALONE VERSION of Deneb Visual. I hope this can help you solve the issue!

[@PowerBIPark]

Super awesome,. thanks for sharing :)

[@ivannavarrete4111]

@@PowerBIPark Thanks to you ! it's an amazing work you did ! and Thanks for sharing this video with all of us! Thks a lot!

[@alexanderkyriakou]

Simply changing the provider to "Vega-Lite" did the trick for me. Thank you for sharing your solution!

[@shekharwadhawan6707]

Showing error in Ln 55 .data should be array

[@lazy_bat_0298]

@@shekharwadhawan6707 I am also getting the same error @PowerBIPark

[@nikhil6ful]

Relevant talk of 45 mins 15 seconds..What a tutorial.. thanks for introducing generative AI for PB

[@PowerBIPark]

Glad you enjoyed it! If you want all the files, I have them available on patreon :)

[@ken_chen]

Not sure if I will ever use those advanced techiniques. But, many thanks for sharing your skills without asking anything in return. This is a great Power BI visual training.

[@PowerBIPark]

Thanks man. I just hope this helps some people, like all the other youtubers helped me get a pbi job 😁🙏

[@eduardofreire3387]

found the code, it was in front of my face and I looked at the description, lol.... Continue with this excellent work. Today, I will follow the talk at Microsoft. Thanks!

[@harshith4484]

Hi, I know many people are struggling to create a Heat Map Visual. Here's what worked for me: 1. I didn't change the KPI name. 2. Click on 'Apply Changes,' after you update the KPI name in line number 41, then go to 'Edit Specification' and 'Field Mapping' (in the header code editor), and apply the mapping. I hope this helps!

[@abdessamadabidaoui7907]

I tried this and it didn't work

[@ujasrudani]

Thanks It worked

[@cesartobar6564]

Thank you! It worked!

[@PGCodeRider]

You are THE up and coming power BI/tech tutorial. There is a high demand for more advanced (but not crazy) tutorials out there. This is great. Nice artistic mix too

[@PowerBIPark]

Wow that's high praise. Thanks! I'm going to release more as soon as I kick this cold 😁

[@ryuhayabusa3540]

Is there a channel like this for Tableau? Don't get me wrong great video and I'm very impressed.

[@ThomasLaussermair]

Great tour of advanced dashboard techniques with integrations of HTML and Python, including the use of many other tools and visual libraries. Thanks for putting this together! Near the end, for the reset functionality overlaid on the circular arrow, I used a single button with a Bookmark action. Good to know about the Clear all slicers functionality.

[@PowerBIPark]

Nice, you watched the whole thing :D Honestly, I was in the same place as you, I recorded at first with the bookmark action, but the clear all slicers did come out a couple releases ago, so I thought it was worth re-recording for this :)

[@randym5515]

Thank you for this. It is so helpful seeing an actual nice development from the start with concise and clear instruction.

[@ngocnguyenhong6732]

Your presentation is super clear and the end result is definitely impressive! Even as a professional, I pick up a lot of useful tools while watching your videos, and I hope you carry on this momentum and enthusiasm for your next endeavors.

[@PowerBIPark]

That's such a nice message to read. Thank you :)

[@Cloudsofa]

one of the most valuable presentations so far. Please do more of this. Thank you for your dedication!

[@PowerBIPark]

Thanks so much 🙏

[@vishalraj8902]

I just found your channel. You are a genius!

[@PowerBIPark]

Welcome aboard!

[@eduardoferreira467]

I managed to finish!! Park, first, thank you very much for taking the time and sharing this incredible and very educational knowledge. I learned a lot from building this project.

[@sanket.hande9]

Nice dashboard mate. Can you upload image background image in description? ( I don't have office 365)

[@Datapassenger_prashant]

Ohh my Goodness.. what the heck 8 have just seen .. i cant believe all such things can happen in power bi ... I am just learning oower bi and here i have seen the God level power bi file .. Simply mind blowing...

[@lofi_Insomnia_]

Nice tutorial! As Mac user, I only have access to Power BI Service (The Web version). I wish there's a tutorial series that only tailors to the web. Until we have Power BI Desktop for Mac, this would be the best we could have.

[@eduardoactd]

Maaaaan crazy vid!!! i just adapted to give a new look to my company's reports and looks awesome! thanks! Suscribed!!!

[@PowerBIPark]

Awesome! I hope they give you recognition for it 😁

[@matiasmandelman9698]

After investigating why the heatmap in Deneb is not working for most people, I have managed to correct it: points to take into account when modifying the code: 1: in my case, that I work in Spanish, replace the months and days by the exact names that appear in each column. "Jan" for "ene" or "Mon" for "lu." 2: replace all the "keys" by their original name. That is, all the "__0__" by "Day of Week"," __1__" by "Month" and "__2__" by the name of the metric, in my case, "_Track". Although I believe that only by performing point 2 it works correctly. I have done this and it worked, so please comment if you can correct it.

[@eduardoferreira467]

Matias, It worked, I got it here. Thank you for your help with the resolution! Let's go!! Hugs, Edu | São Paulo | Brazil

[@ChatPowerBI]

👏 great! I wonder when Power BI will allow us to format objects like Power Point so we don't have to go back and forth between tools to adjust the layout

[@fawadyusuf]

Wow...too much info to digest for someone who is "Trying" to learn Power BI ;) Excellent video!

[@jadejenkins7515]

Great video, very informative. Only got the free Chat-GPT, so decided just to use the code provided above, if anyone else gets an indentation error, you can use the free version of Chat GPT to format to code to correct the structure. Also I got the following error: KeyError: 'artist_name'. On closer inspection of the data set, artist_name is actually "artist(s)_name". If you correct this in line 52, it should fix the problem.

[@PowerBIPark]

Thanks for sharing!

[@heljava]

Amazing demo. Learned a lot. I will be applying some (most) of the things of this video to my projects. Really helpful content and clearly explained. Thank you very much!

[@PowerBIPark]

Appreciate the feedback! I hope it helps you in your work 😁

[@DhrubajyotiPatra]

@@PowerBIPark hi sir i loved you video, but I am having a difficulty in the deneb visual heatmap code of github that name chnaing trick is not working for Me, I am not able to see any dropdown or option for the edit configurations field mapping option so it is remaining on NAN, Undefined values although I have the changed that KPI name to track, but not helping, if you can provide me any resource or help me in it , I will be highly grateful.

[@naren9603]

The Deneb heatmap visual is not showing up for me even though I clicked the edit button and changed the name n number of times.

[@FredericLEGUEN-Excel]

Wow! Impressive. Now it's time for me to practice because nothing is easy. Can you please add Chapter in your video? That's really important to navigate, especially for such a long video

[@PowerBIPark]

Actually great feedback, thanks!

[@TenhoDados]

So wonderful. Congratulations you deserve millions of likes 👏 👏 👏

[@PowerBIPark]

That's such a nice comment, thank you :)

[@arjunsaini9725]

This look super cook. Didn't knew power BI can do this. I learned something new from this. Thanks

[@joaorataoo]

An extraordinary presentation. I learned a lot, and it's clearly a higher level of reporting. Just out of curiosity, I wonder how long it would take an expert like you to develop this report. Big thanks!!!

[@PowerBIPark]

Thank you so much. So everything took me 2 afternoons, but I had to wait because I reached out to David for the unit chart code. I might have been able to do it faster, but I spent a lot of time on fixing the PowerPoint, and trying to see how much% transparency would look nicer 😂

[@Clemzysmith]

I’ve been looking for something like this for so long. Thank you so much!!

[@banihas22]

I can't wait to try this out on the weekend! Thanks for taking the time to put this together 😊

[@PowerBIPark]

Have fun!

[@rupasanjana2678]

hey have you done this i really want excel file with urls or i' happy if you guide me

[@aliikhlaq]

You done this with detail. being a new to PowerBI i learn a lot Thank you

[@PowerBIPark]

I'm happy to hear that, this video is to help people like you 🙏

[@ShirishaB-wk9zf]

Great video !! between i have a problem in the heatmap visual. I have the changed the settings from SVG to Canvas and using a Vega-lite. May i know where the second place is do we need to change the code. would be helpful to complete the report. Thanks!

[@rashmikrishnamohan1736]

Definitely gonna try this out! Will share my output soon! Thanks for sharing!

[@PowerBIPark]

You bet!

[@TrackPowerBi]

Great video! Step by step! I really like this view! Now I'm your fan! I'm waiting for the next video! :)

[@PowerBIPark]

Thank you so much!

[@ThoNguyen-kq7ob]

Bro this is fire. Thank you! Keep making the content!

[@PowerBIPark]

Thanks, appreciate it :)

[@AuthyDrains151]

@@PowerBIParknice

[@themindhelp9584]

omggg I subscribeddddddddddd immediately!! thank youuuuuuuuuuuuuu...and please continue doing them

[@TheAmazingmayowa]

i just completed the video, thank you

[@TheAmazingmayowa]

@DogsInMumbai hi dear.I will go through my notes and get back to you .

[@manggnorora]

I have been waiting for this one.

[@predatorleader]

Perfect presentation/training i loved it very much ! keep up the great work :)

[@juanignacioXI]

Just amazing!!, great work Mr. Park.

[@thomasd8888]

Thanks so much for the valuable presentations!

[@applepeel1662]

Superb!! Will be adding this to my portfolio project

[@tobiazeez4188]

This looks absolutely amazing!! Definitely will be trying this

[@PowerBIPark]

Let me know how it goes!

[@excel-solutions4564]

Amazing tutorial.. Looking forward to practice all these amazing techniques.

[@marymargaret8724]

Amazing😍, Bless U for ur knowledge Sharing, expecting more, thank you

[@PowerBIPark]

😁

[@GabrielFerreira-ip4wh]

Awensome content, thanks for sharing, brazil here 🎈🎈

[@albertroy9620]

Finally made everything but only that heat map was giving problem so used alternative for it rest was nice experience doing it

[@PowerBIPark]

A lot of people had problems with the heatmap after deneb 1.6 came out :( there is a resolution in the pinned comments though :)

[@jasonthegentleman2992]

This is an awesome video man, this Deneb visual is next level with the provided resources. thanks to @SupernovaSmith for directing me to it!

[@PowerBIPark]

Glad you enjoyed it!

[@anushkapanikulam2023]

In the slicers using the released_year eliminates the possibility of having a year with no songs released

[@ahmedantar9114]

Thanks for that video it gives me a lot of INSPIRATIONS🎊 , what is the version of that power bi ? as i found a new features that can make easier to work !💥

[@nishikantanayak7797]

so beautiful so elegant just looking like a wow

[@Aestheticvibe2004]

please more videos like this

[@adityadash1320]

When I tried the html code and tried to click on Image html, its not working, no image shows up, it says image html on a a blank white screen. Am I missing anything? I even changed the data category of cover_url to Image URL and the image shows in that column but not in the above step as shown.

[@SDSYoutube]

Great video. Thanks for this. Lots of great info here!

[@PowerBIPark]

Thanks Andrew. Most "end-to-end" Power BI tutorial videos on YT are very basic, so I wanted to make something a tiny bit more advanced 😎

[@eduardoferreira467]

Park, I need help, just from the specialist, I'm stuck in the heat map, I saw that some colleagues do too, my measurement (_Track = count('Spotify Dataset (3)'[track_name]) doesn't work, (even following the step by step) I tried everything and Deneb the table always returns the amount of line 953, it is not counting the number of tracks, can you help?

[@matiasmandelman9698]

I solved it in my comment!

[@eduardoferreira467]

@@matiasmandelman9698 Matias, It worked, I got it here. Thank you for your help with the resolution! Let's go!! Hugs, Edu | São Paulo | Brazil

[@dr.nehachaudhry3526]

Thanks for sharing this amazing project👍ll definitely try this 🙂

[@PowerBIPark]

Great, I hope it is educational for you 😁

[@dr.nehachaudhry3526]

@@PowerBIPark yes, it is

[@sathishgudri4332]

I think there is a problem with the horizontal bars in calender heat map. Friday is the day with most tracks, however the bars showing more weight on Saturday. Also, if you select a track which is released on Friday, the heat map will show it as Friday but the horizontal bar shows it as Saturday.

[@sathishgudri4332]

The problem is that the weekdays are in lowercase at 2 places in the code section, out of which one, related to the heatmap was fixed by capitalizing the first letter at line number 72 (demonstrated in the video). The other one, related to the bars, remained in lower letters and needs to be fixed for the bars to work properly. You can find the other section at line number 137.

[@dganalysis]

Great comprehensive video Park 💪

[@PowerBIPark]

Thanks Gerard!

[@srajaldeepshukla]

bro i really need the python code, That code isnt working which is in description. please help

[@sumayeablash952]

Just wooooooooooooooow... Amazing

[@roberttyler2861]

Cannot for the life of me get this to work. The heat map doesn't recognise my measure. so fustrating haha. just following the steps.

[@eduardoferreira467]

I'm in this too, did you manage to solve it?

[@roberttyler2861]

@@eduardoferreira467 na gave up.

[@fereschoura4323]

i tried many times the column for data['cover_url'] but doesn't work it shows me soo many urls when i click to one of them it redirect me and appear an xml error i don't know what to do?

[@preciousime2643]

thank you for this video. i really enjoyed it.

[@PowerBIPark]

Your final product looks great. Well done!

[@DPaquette]

The image size for album cover does not fit the window size in the html window I tried even at 45% and higher pixels for W & H.

[@vishalrakhecha2805]

Great video! I was wondering if it's possible to achieve similar functionality with Python instead of HTML? I'm building a stock dashboard with a dropdown menu for stock selection. Ideally, upon selecting a stock symbol, the script would dynamically fetch data (open, close, high, low, etc.) and update the visualization, similar to how you achieved image updates with HTML. I have access to a Python script containing the API for data retrieval. My goal is to automate data retrieval for hundreds of stocks instead of manually uploading it. In short, can Python automatically pull data from a website using an API, similar to how HTML updates images?

[@gungunmishra2484]

thankyou so much for this valuable content

[@uchiha_sasuke_48]

🤤that thumbnail is asking me start this project immediately and learn something new.

[@PowerBIPark]

I hope you do learn something useful :)

[@uchiha_sasuke_48]

Before starting this project, I just want to make myself clear. Can I complete this whole project for free without any deviations. I can observe that you're using ChatGPT 4. But I've only ChatGPT 3. Can I get that Spotify client ID for free. Until now I haven't used Spotify at least once in a life.

[@PowerBIPark]

The only paid item that I use is ChatGPT-4, but everything else is free, including spotify APIs.

[@_ARYANYUAN]

while doing the spotify test app step what URL to be put in the required url box?

[@SaroashRahil]

Hello. First of all thanks for the amazing video. Second, I cant seem to get the heatmap right. I get an empty mapping window after changing the _Track name everytrime. Help me out please

[@matiasmandelman9698]

I solved it in my comment!

[@alexandros27.]

Not quite sure If the measure for returning the top strong streams is correct . It returns the maximum stream afrom all the values in the column in the end but messes up inside the row context

[@jamilleghazaleh9627]

I tried everything but still everytime it shows the html code instead of the image. I already checked the measure 100x and I even changed the type of colum to "Image URL" but nothing works

[@aizazzizu1525]

It's amazing but unfortunately I'm not on that level right now and you didn't have any videos on your channel for beginners.

[@PowerBIPark]

That's okay - I hope this becomes useful maybe in the future 😁

[@aizazzizu1525]

@@PowerBIPark 🤣 Hope so. Keep it up

[@bhargavi-d8x]

Each time i run to accress the track details and its cover url, it returns NONE

[@AhmedGamal-mi1ns]

I thoroughly enjoyed watching this video. It's not every day that you come across advanced projects like this available for free on the web. However, I do have a request. I currently only have access to GPT-3.5, and I find it a bit challenging to work with code. Could you please share the code with me?

[@PowerBIPark]

Thanks Ahmed. Check out the description, the code is there 😊

[@mohsinbaig9326]

Superbly done!🤩 How do you get the right option pane (from where you selected the format pane or selection pane) in your PowerBI? How can I get that in my Power BI?

[@PowerBIPark]

Great question, it's actually the on-object formatting. A lot of people don't like it because it's not 100% intuitively made. You can turn it on through the preview settings in the power bi desktop (just google power bi on object settings) 😁

[@Yog3shPatel]

Hi If you can also provide the background image in discerption that will be a great help. Please Bro?

[@FridaDaniel]

Great Inspiration! Definitely taking part this month!

[@PowerBIPark]

You got this!

[@duudiduudu]

why is my excel formated so weird when i open it? All the data is in one cell on each row

[@laszlokenez7685]

Not the biggest deal in this particular project, but the ultimate nightmare of messing with something that we do not entirely understand is that we display wrong data. It is just too risky. At 28:08, as you update the weekdays in order to sort the rows properly, the rightmost bars remain unsorted.

[@PowerBIPark]

Nice catch! I had it as the top pinned comment that you needed to change the days in 2more places in the code, but I couldn't pin more than one comment at a time. At least it doesn't take too much away from learning the tools 😊

[@claudiozadorosny4722]

Very good

[@Hamza12123]

good work

[@sarakadam438]

I wish there was more reasoning whenever you're doing something new like 'replacing " with single ', idk why :p

[@PowerBIPark]

It's because double quotes are used in DAX to signify strings xD

[@hepingliu5344]

What a great demo! Is possible to change the label font size the Month and the Days of Week in the Deneb Heatmap? Thanks a lot.

[@ydeevlog4825]

for me heat map is not coming i cant save the mapping the dialog box is not coming

[@vikashkumarmahato6461]

Cant wait to try it ,is there any links or data or code i need other than those mentioned in the description. i have connected with you on linked in for the lovely work you do

[@PowerBIPark]

Reach out to me on linkedin, ill send you any code you need :)

[@neelimaneelu2792]

Sir can i image url based on the order id's of amazon, is there any possible things

[@santoshingle3977]

Hi, This is great video. But I'm facing a problem with deneb specification field mapping. I don't see columns to map when kpi name is changed.

[@PowerBIPark]

I saw a different person tried this approach, and it worked for them: 1. I didn't change the KPI name. 2. Click on 'Apply Changes,' after you update the KPI name in line number 41, then go to 'Edit Specification' and 'Field Mapping' (in the header code editor), and apply the mapping.

[@shahzadkheros]

amazing!

[@JesusGil90]

hello, I would like to ask you something, is there any way to consume data from the Power BI report? for example, query those averages and use it in a PHP, Node etc application.

[@ome9034]

could you send entire python code at once in one file , mentioning what all things we need to change?

[@nakul--]

Can i get the python code in some file form , This is dropping errors..

[@baanusai7395]

Cant help my self but notice that the data set from kaggle has an error where the Column: stream has an error data for row 576. (error entry :- BPM110KeyAModeMajorDanceability53Valence75Energy69Acousticness7Instrumentalness0Liveness17Speechiness3) would be really helpful if anyone can comment the accurate data.

[@nirajmahajan2147]

Where can I get the python code to get urls in the dataset?

[@ShubhamSharma-d7l]

can you please solve my query regarding that average stream per year i am getting error there about allexcept syntax that year is not there

[@bhargavi-d8x]

how to convert the column dragged into slicers?

[@ydeevlog4825]

hi for me that Deneb tool editing and spacing is coming in a blank screen cant update the changes what is the solution 27:14

[@matiasmandelman9698]

I solved it in my comment!

[@arpithagangatkar580]

kzbin.infoE2wjo4FaVjk

[@sakshem]

Choose vega-lite after selecting deneb visual and follow the same process mentioned in the video

[@sudheendranekkanti9471]

Hey @Power BI Park I'm facing a problem at Deneb Heatmap where it's not showing the heat map even though I changed the name of track measure multiple times... any thoughts on why this is happening ???

[@parthdeshmukh1834]

I am facing the same problem

[@DhrubajyotiPatra]

yes man i m facing the same problem too. any suggestion on how can we proceed.

[@arpithagangatkar580]

kzbin.infoE2wjo4FaVjk

[@ewdlop1]

Thanks!

[@PowerBIPark]

Wow my first super thanks. 🍻

[@RedCloudServices]

Is it possible to add a chatbox and open source LLM like Llama instead of openai?

[@neelimaneelu2792]

I want to done this project with yellow theme, is there any problems may raise for doing with yellow theme, because Spotify colour is green.

[@PowerBIPark]

Do it anyway you like, this is a practice report for you to learn 😊

[@cedvaz1984]

how do you have so much of space on your canvas! I struggle as I feel i cant have enoygh of visualizations in my pwoer bi canvas withour shrinking everything so small, what am i doing wrong help!!

[@PowerBIPark]

Change your canvas size my dude :)

[@willywales9446]

I have a challenge on power BI that I would like to discuss it with you.

[@abdessamadabidaoui7907]

Thank you for this amazing project, i tried making the heat map following exactly the steps that you have done and still didn't work do you have a follow up on how to make it work.

[@PowerBIPark]

Hey the answers in the comments I think I pinned it as the answer because a lot of people had issues after deneb was updated

[@abdessamadabidaoui7907]

@@PowerBIPark Thank you so much for giving time to my comment, i tried it as well and it didn't solve the problem. but anyway that's just pushed me to wanting more to learn how to make heatmaps and visuals in deneb, i'll be making one of my own. thanks again and i'll always follow your videos. please make more tutorials like this :D