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!
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.
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
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!
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.
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 :)
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.
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.
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
Thats really advanced stuff! And your voice and delivery is fantastic!!! Thank you! Can you make the tutorial how to create custom visual with chatgpt inside your Power Bi dashboard?
Python and HTML code is in the description (although you need to edit the HTML code) Make sure that you edit the Days in the heatmap code in 2 places! - I only mention one, but there's another place you need to fix it to order the side bar
@@parthdeshmukh1834 did you able to get the heatmap visual from deneb, cause that name changing trick is not working for me , I am not able to see any options in edit configuration field mapping , can you help me with that?
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!!!
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 😂
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 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.
@@PowerBIParkactually there is not updated Spotify data only old data Spotify 2023 is got so no cover url is there please help in giving me and adding the tools besides was though
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...
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.
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.
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!
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.
👏 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
Great video, thanks a lot for all the insights. Unfortunately I am struggling with the deneb visual for the energy level. Even though I remove the background coding and switch off the background in the visual settings the background is still there. Do you have any idea how to solve it? Thanks a lot.
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.
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.
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"
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!
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.
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 😊
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?
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?
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
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.
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
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 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
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 ???
A very honest question for all dark theme. In dark theme, the word,label or value must be white color/light color something like that to let the value visualable. but if the value is in white color, the value cant be seen in focus mode. i really need a solution to solve this problem
At 11:59 you are changing canvas settings, but my version of PowerBI, a paid license, does not have this option. Is there an alternate way of getting to that menu?
@@PowerBIPark thanks for your reply, eventually found it, after a half dozen bing searches of the term "PowerBI canvas settings". I am 100% new and fighting against fatigue/frustration with PowerBI.
@@PowerBIPark Thanks! With a good attitude and lots of determination, I am finally getting the hang of it. Thanks for your help! I am subscribed to your channel.
Can i use this project as a portfolio project for my job hunt as a data analyst or will I not be able to use it as it is made by someone else and I am just coying it. Please reply.
Very clearly, if you put it in your portfolio, and someone recognises it, then hopefully they will know you've started the journey to advanced reporting. I don't mind if you do at all - but it's always better to be honest that it is a guided project, than be rejected because you put it as your own work and it was recongised. I hope this helps!
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?
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) 😁
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.
Fantastic video. Just a question, I want to create a report like that for my company, being more specific, for the connectivity department. Do you know if is possible to use Python if my datasource comes from Sharepoint? I also want to know if make sense to create a report like that using Deneb function for any type of report.. I mean there is always a possibility to structure my data to fit with these type of visuals? In my personal case, I need to represent the launching dates of each site within specific technology. Thank you very much
Hi Julian, so it's possible, but if you want to integrate python into your process, it's better for that to be in synapse or fabric. Power bi(or more specifically power query) does not handle python too well, but this is not an issue in fabric. On the other hand, there are hundreds of deneb templates, you can go check out the deneb documentation website, and there's a lot of good ones to start. I always use it as a last resort, or if I really want to impress someone, because deneb is still a lot more work than regular visuals 😁
Thanks for sharing How much it will take time for preparing updated_file.csv? When I write command like Python SpotifyScript.py ....then it took too much time and then nothing happens... can't able to create updated_file.. any suggestions
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 !💥
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
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?
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.
The dashboard looks really attractive. I am looking forward to working on this. Is there a way I can get the python code as I do not have access to ChatGPT- 4 ?
Sure man, reach out to me on linkedin and I'm happy to send you the python code or the excel with the cover URLs already there. The excel will also be released for download on Monday
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.
I am stuck on the step where I have to run Python script_name.py command. I am guessing it is due to my old processor(intel celeron)!!? Do I need more powerful processor for this to run as I checked the code multiple times and there is no issue with it? Any ideas can be helpful🙏
Hello Power BI Park Can i help me solve the issue ? Heatmap when i rename measure from track to _track. And edit deneb then no show edit specification field mapping. Error because rename measure track. Thank you for you !
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!!
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?
I got you! Check this learn.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops&tabs=private#add-last-refresh-date-based-on-a-power-bi-or-odata-query
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!
Super awesome,. thanks for sharing :)
@@PowerBIPark Thanks to you ! it's an amazing work you did ! and Thanks for sharing this video with all of us! Thks a lot!
Simply changing the provider to "Vega-Lite" did the trick for me. Thank you for sharing your solution!
Showing error in Ln 55 .data should be array
@@shekharwadhawan6707 I am also getting the same error @PowerBIPark
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.
Thanks man. I just hope this helps some people, like all the other youtubers helped me get a pbi job 😁🙏
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
Wow that's high praise. Thanks! I'm going to release more as soon as I kick this cold 😁
Is there a channel like this for Tableau? Don't get me wrong great video and I'm very impressed.
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!
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.
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 :)
one of the most valuable presentations so far. Please do more of this. Thank you for your dedication!
Thanks so much 🙏
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.
That's such a nice message to read. Thank you :)
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.
Thank you for this. It is so helpful seeing an actual nice development from the start with concise and clear instruction.
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
Actually great feedback, thanks!
Wow...too much info to digest for someone who is "Trying" to learn Power BI ;)
Excellent video!
Thats really advanced stuff! And your voice and delivery is fantastic!!! Thank you! Can you make the tutorial how to create custom visual with chatgpt inside your Power Bi dashboard?
I’ve been looking for something like this for so long. Thank you so much!!
Python and HTML code is in the description (although you need to edit the HTML code)
Make sure that you edit the Days in the heatmap code in 2 places! - I only mention one, but there's another place you need to fix it to order the side bar
I am having problem with this heatmap code. Can you please help me in this.
@@parthdeshmukh1834 did you able to get the heatmap visual from deneb, cause that name changing trick is not working for me , I am not able to see any options in edit configuration field mapping , can you help me with that?
I am having problems in line 55. .data should be in array code
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!!!
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 😂
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!
Appreciate the feedback! I hope it helps you in your work 😁
@@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.
Relevant talk of 45 mins 15 seconds..What a tutorial.. thanks for introducing generative AI for PB
Glad you enjoyed it! If you want all the files, I have them available on patreon :)
@@PowerBIParkactually there is not updated Spotify data only old data Spotify 2023 is got so no cover url is there please help in giving me and adding the tools besides was though
I can't wait to try this out on the weekend! Thanks for taking the time to put this together 😊
Have fun!
hey have you done this i really want excel file with urls or i' happy if you guide me
Maaaaan crazy vid!!! i just adapted to give a new look to my company's reports and looks awesome! thanks! Suscribed!!!
Awesome! I hope they give you recognition for it 😁
This look super cook. Didn't knew power BI can do this. I learned something new from this. Thanks
So wonderful. Congratulations you deserve millions of likes 👏 👏 👏
That's such a nice comment, thank you :)
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...
Thanks!
Wow my first super thanks. 🍻
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.
Matias,
It worked, I got it here.
Thank you for your help with the resolution! Let's go!!
Hugs,
Edu | São Paulo | Brazil
Thanks so much. This one actually worked. Changed all the __0__/__1__/__2__'s to their respective names
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.
Thanks for sharing!
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!
I tried this and it didn't work
Thanks It worked
Thank you! It worked!
I just found your channel. You are a genius!
Welcome aboard!
Definitely gonna try this out! Will share my output soon! Thanks for sharing!
You bet!
You done this with detail. being a new to PowerBI i learn a lot Thank you
I'm happy to hear that, this video is to help people like you 🙏
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.
Great video! Step by step! I really like this view! Now I'm your fan! I'm waiting for the next video! :)
Thank you so much!
Bro this is fire. Thank you! Keep making the content!
Thanks, appreciate it :)
@@PowerBIParknice
Perfect presentation/training i loved it very much ! keep up the great work :)
Awesome content, many thanks from France, I achieved to make it including the deneb calendar 🙂 but it tooks me more than 45 min ;-) ;-)
This looks absolutely amazing!! Definitely will be trying this
Let me know how it goes!
omggg I subscribeddddddddddd immediately!! thank youuuuuuuuuuuuuu...and please continue doing them
👏 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
i just completed the video, thank you
Can u please provide me Spotify _script code
@@DogsInMumbai hi dear.I will go through my notes and get back to you .
@@TheAmazingmayowa thank you
@@TheAmazingmayowa hey?
Superb!! Will be adding this to my portfolio project
Nice dashboard mate.
Can you upload image background image in description? ( I don't have office 365)
Just amazing!!, great work Mr. Park.
Great video, thanks a lot for all the insights. Unfortunately I am struggling with the deneb visual for the energy level. Even though I remove the background coding and switch off the background in the visual settings the background is still there. Do you have any idea how to solve it? Thanks a lot.
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.
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.
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.
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"
I have been waiting for this one.
Amazing tutorial.. Looking forward to practice all these amazing techniques.
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!
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.
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 😊
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?
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?
I solved it in my comment!
@@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
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
Reach out to me on linkedin, ill send you any code you need :)
Amazing😍, Bless U for ur knowledge Sharing, expecting more, thank you
😁
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.
Thanks for sharing this amazing project👍ll definitely try this 🙂
Great, I hope it is educational for you 😁
@@PowerBIPark yes, it is
Heatmap unable to move from it I got stuck and with the coverurl it isn't in source
#powerbipark
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
I solved it in my comment!
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.
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
@@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
Finally made everything but only that heat map was giving problem so used alternative for it rest was nice experience doing it
A lot of people had problems with the heatmap after deneb 1.6 came out :( there is a resolution in the pinned comments though :)
Great tutorial ! Thank you so much !
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
I solved it in my comment!
th-cam.com/users/shortsE2wjo4FaVjk
Choose vega-lite after selecting deneb visual and follow the same process mentioned in the video
Great video. Thanks for this. Lots of great info here!
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 😎
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.
for me heat map is not coming i cant save the mapping the dialog box is not coming
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.
That's okay - I hope this becomes useful maybe in the future 😁
@@PowerBIPark 🤣 Hope so. Keep it up
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 ???
I am facing the same problem
yes man i m facing the same problem too. any suggestion on how can we proceed.
th-cam.com/users/shortsE2wjo4FaVjk
so beautiful so elegant just looking like a wow
A very honest question for all dark theme.
In dark theme, the word,label or value must be white color/light color something like that to let the value visualable.
but if the value is in white color, the value cant be seen in focus mode.
i really need a solution to solve this problem
At 11:59 you are changing canvas settings, but my version of PowerBI, a paid license, does not have this option. Is there an alternate way of getting to that menu?
Are you using the on object settings?
@@PowerBIPark thanks for your reply, eventually found it, after a half dozen bing searches of the term "PowerBI canvas settings". I am 100% new and fighting against fatigue/frustration with PowerBI.
Hang in there! This is maybe a little bit difficult for a beginner, but let me know how it goes 😄
@@PowerBIPark Thanks! With a good attitude and lots of determination, I am finally getting the hang of it. Thanks for your help! I am subscribed to your channel.
Can i use this project as a portfolio project for my job hunt as a data analyst or will I not be able to use it as it is made by someone else and I am just coying it.
Please reply.
Very clearly, if you put it in your portfolio, and someone recognises it, then hopefully they will know you've started the journey to advanced reporting.
I don't mind if you do at all - but it's always better to be honest that it is a guided project, than be rejected because you put it as your own work and it was recongised. I hope this helps!
I see thanks for clearing my doubt regarding this and for replying so fast I have just finished watching your vedio.
No problem, I hope it clarifies things 🙏
@@PowerBIPark yup it does.
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?
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) 😁
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.
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.
Awensome content, thanks for sharing, brazil here 🎈🎈
Fantastic video. Just a question,
I want to create a report like that for my company, being more specific, for the connectivity department. Do you know if is possible to use Python if my datasource comes from Sharepoint?
I also want to know if make sense to create a report like that using Deneb function for any type of report.. I mean there is always a possibility to structure my data to fit with these type of visuals?
In my personal case, I need to represent the launching dates of each site within specific technology.
Thank you very much
Hi Julian, so it's possible, but if you want to integrate python into your process, it's better for that to be in synapse or fabric. Power bi(or more specifically power query) does not handle python too well, but this is not an issue in fabric.
On the other hand, there are hundreds of deneb templates, you can go check out the deneb documentation website, and there's a lot of good ones to start. I always use it as a last resort, or if I really want to impress someone, because deneb is still a lot more work than regular visuals 😁
@@PowerBIPark Thank you very much for your feedback. Your content is amazing.👏🏻
Great comprehensive video Park 💪
Thanks Gerard!
In the slicers using the released_year eliminates the possibility of having a year with no songs released
Thanks for sharing
How much it will take time for preparing updated_file.csv?
When I write command like Python SpotifyScript.py ....then it took too much time and then nothing happens... can't able to create updated_file.. any suggestions
It depends, but in 10 tries the longest took me 10 mins. Take the first link in the description for the enriched dataset 👌
@@PowerBIPark Okay Thanks
Great Inspiration! Definitely taking part this month!
You got this!
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 !💥
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
thank you for this video. i really enjoyed it.
Your final product looks great. Well done!
I wish there was more reasoning whenever you're doing something new like 'replacing " with single ', idk why :p
It's because double quotes are used in DAX to signify strings xD
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?
Thanks Ahmed. Check out the description, the code is there 😊
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.
while doing the spotify test app step what URL to be put in the required url box?
Hello, great dashboard !! How can I get the PPT template since I do not have the designer tag on my powerpoint
You can use any background design from Google, no designer needed 😁
The dashboard looks really attractive. I am looking forward to working on this. Is there a way I can get the python code as I do not have access to ChatGPT- 4 ?
Sure man, reach out to me on linkedin and I'm happy to send you the python code or the excel with the cover URLs already there. The excel will also be released for download on Monday
@@PowerBIPark That's very kind of you. You are awesome :)
🤤that thumbnail is asking me start this project immediately and learn something new.
I hope you do learn something useful :)
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.
The only paid item that I use is ChatGPT-4, but everything else is free, including spotify APIs.
please more videos like this
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.
I'm in this too, did you manage to solve it?
@@eduardoferreira467 na gave up.
This is an awesome video man, this Deneb visual is next level with the provided resources. thanks to @SupernovaSmith for directing me to it!
Glad you enjoyed it!
I am stuck on the step where I have to run Python script_name.py command. I am guessing it is due to my old processor(intel celeron)!!?
Do I need more powerful processor for this to run as I checked the code multiple times and there is no issue with it?
Any ideas can be helpful🙏
bro i really need the python code, That code isnt working which is in description.
please help
Great video, very informative. I am not able to find designer section in my PowerPoint. Please help me
It's okay not to use the designer, just use any photo and change the settings with picture formatting from PowerPoint
thankyou so much for this valuable content
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.
Do it anyway you like, this is a practice report for you to learn 😊
Hello Power BI Park
Can i help me solve the issue ?
Heatmap when i rename measure from track to _track.
And edit deneb then no show edit specification field mapping.
Error because rename measure track.
Thank you for you !
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.
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!!
Change your canvas size my dude :)
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?
On the track image like blinding light html content, im getting a slicer which is shifting the picture to left and right, up and down. How to fix it?
it's because the html visual is too small. You need to adjust the width and length in the code, or make the visual bigger
Thanks for sharing knowledge.. I Need Help ‘how to show the last refresh date on dashboard.. need date from power bi service schedule refresh date.
I got you! Check this learn.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops&tabs=private#add-last-refresh-date-based-on-a-power-bi-or-odata-query
@@PowerBIPark Thanks but this won’t work on published report.. everytime time I can’t manually refresh the dashboard from desktop