Create a theme for power bi with following things 1) Neon colors for charts with red and blue color mandatory 2) X & Y axis size should be 15 3) Data labels size should be 15 4)Border and shadow to the charts
Thanks Pavanj. I was wondering how i could format multiple objects at the same time and i was thinking it has to be a VBA solution -but your solution if far better. Thanks you
Hi Pawan I’ve followed same steps as you did but for some reason I am getting json code which is not exactly same as yours and it is showing when I try to load the theme what can I do now
Great video. I have a question though. How do I replace data source with a new File in Power BI automatically? Every week a new flat file is generated and we need to do reporting on latest file. Please advise.
it throws me error. the error is error: there was a problem importing your theme file. the JSON syntax was invalid, missing required property "name" used invalid colors, or provided invalid top-level properties.
Hi Pavan, I have a query related to power bi. I'd like to inquire about a method to add an image to a table visual sourced from either an Excel file or a SharePoint site. I need this image to dynamically change based on filter selections. However, the crucial requirement is that the image should appear in a round shape rather than the default square shape. Currently, when I add the image using its URL, it displays in a square shape. Any guidance on achieving a round-shaped image in the table visual would be greatly appreciated. Thank you! If you can make a video on that would be very helpful..
Sir, i am Getting error " there was problem importing your theme file .The json syntax was invalid ,missing, required property "names invalid colors ,or provided invalid top- level Properties" .Please help
Excuse me Pawan Sir, im learning your Power BI 8 hour class right now and I have got a doubt that "WILL CHATGPT, GOOGLE BARD and etc... AI tools will replace POWER BI ANALYSTS ! PLEASE REPLY SIR ? PLEASE PLEASE PLEASE REQUEST
Hello Sir , A Small doubt . I am using a power BI version of 2023 , as you said chat gpt supports till Sep 2021. Is there a way i can convert json code to support the latest version
Evening Sir, I'm learning Power BI through your YT videos hear i have one doubt I have 1.5 Years of carrier gap so can i expect Job as a Power BI developer.? suggest me
Hello Sir, I have 3 tables in 3 different work sheets of the same work book. One is Main Data Table, 2nd is Block Names with code against each name, and the 3rd is Craft Names with codes against each name of the Craft. The problem is that I have to add two columns (Block & Craft) to the Main Data Table on the basis of the codes which are embedded in one of the columns (Registration Number) of Main Data Table . In Registration Number Column, the craft and block are embedded in the form of codes which are separated by delimiter dash (-) Please write a dynamic power query code. I will provide the list of Blocks & Crafts The Blocks will remain only 8 in number and wouldn't change but the list of Crafts may change/increase in future. Therefore, if there is any addition in the Craft that should be automatically added. Example of Registration Number Column: ADHS-SFK-CPWS-01 ADHS-SHL-KS-01 ADHS-RAM-CPT-106 ADHS-SR-CRL-015 ADHS-PTH-KTS-066 ADHS-GDB-TAP-217 ADHS-SKDLA-SZ-07 ADHS-SKDLB-STP-044 In the above Registration Number column, the coding for Crafts is as undder: CPWS= Copperware Sakhta KS= Kani Shawl CPT= Carpet CRL= Crewel KTS= Katas TAP= Tapestry SZ= Sozni STP= Stapple and the coding for Blocks are: SFK= Safakadal SHL= Shalimar RAM= Rambagh SR= Soura PTH= Panthachowk GDB= Gadoodbagh SKDLA= Saidakadal-A SKDLB= Safakadal-B Please make a video on this....
This chatgpt is entirely understanding our questions very well like a human..... really I am using this a lot and got afraid about future jobs
Your Video theme was matching you Shirt 👕 today👍
Create a theme for power bi with following things
1) Neon colors for charts with red and blue color mandatory
2) X & Y axis size should be 15
3) Data labels size should be 15
4)Border and shadow to the charts
Wow.. after pasting codes in POWER BI the color of charts changed so much magical things.
Awesome lesson Sir, you are World best mentor for me.
awaiting for new video.
Nice & useful video sir, thank you
Such a wonderful video and easy to understand the concept great job sir.
Amazing way of modifying power bi reports
Thanks for sharing .
Clean and crisp explanation .. Amazing
Thanks sir alots 🙏🙏🙏🙏🌹💐🙏🥰😍....
Your video are awesome, Thank you so much ,it's very much interesting and informative.
Excellent video
Seriously cracking
Excellent
Superb sir
Amazing
Thanks so much for this video
Good information sir
You are great sir.
You are the great sir..
Lol, I liked the ending music a lot, Thanks...
Thanks Pavanj. I was wondering how i could format multiple objects at the same time and i was thinking it has to be a VBA solution -but your solution if far better. Thanks you
Welcome
Thanks sir, it's Really useful.
Please create some shorts for simple tips
Brilliant video for real world case use. New subscriber now as well. Very detailed and informative
Hi sir, how to build reports smoothly as you did, which features in power bi desktop we should enable... ???
Hi Pawan I’ve followed same steps as you did but for some reason I am getting json code which is not exactly same as yours and it is showing when I try to load the theme what can I do now
You the great Guruji
Great video. I have a question though.
How do I replace data source with a new File in Power BI automatically? Every week a new flat file is generated and we need to do reporting on latest file. Please advise.
Filter step needs to be applied ok data and time received
it throws me error. the error is
error: there was a problem importing your theme file. the JSON syntax was invalid, missing required property "name" used invalid colors, or provided invalid top-level properties.
Thankyou for making this video please continue this series
Which tool do you use to record the videos. Your video as well as the video from laptop to simultaneously. 👌
Thanks alot sir
I am always following your channel from starting I got alot knowledge from you ☺️
Is it important to learn SQL before power bi or any other database tool
Thank you sir
Sir, whenever you select / hover anything then red rectangle automatically appear, which tool do you use?
Very good information 🙂🙂
please make video on how to Embed Power BI reports and dashboards into other applications
Am getting an error while importing the code or theme to power bi
Hi Pavan, I have a query related to power bi. I'd like to inquire about a method to add an image to a table visual sourced from either an Excel file or a SharePoint site. I need this image to dynamically change based on filter selections. However, the crucial requirement is that the image should appear in a round shape rather than the default square shape. Currently, when I add the image using its URL, it displays in a square shape. Any guidance on achieving a round-shaped image in the table visual would be greatly appreciated. Thank you!
If you can make a video on that would be very helpful..
Is it work for chatgpt 3.5?
Sir, i am Getting error " there was problem importing your theme file .The json syntax was invalid ,missing, required property "names invalid colors ,or provided invalid top- level Properties" .Please help
worth subscribing channel. very specific and pin pointed what a newbie like me need
Excuse me Pawan Sir, im learning your Power BI 8 hour class right now and I have got a doubt that "WILL CHATGPT, GOOGLE BARD and etc... AI tools will replace POWER BI ANALYSTS ! PLEASE REPLY SIR ? PLEASE PLEASE PLEASE REQUEST
Nope: Not at all. These tools help to make learnings better. Implementations are not now possible as of today
This will take 3 -5 yrs to implement
Thanks, Pavan Sir. It helped us a lot. Immediately I created JSON and using ChatGPT. Implemented in Power BI. Now It looks great. Thanks again
Excellent Ravi
You were fast
Hello can I use chatgpt for accounting related am accounting professional
Hello Sir ,
A Small doubt . I am using a power BI version of 2023 , as you said chat gpt supports till Sep 2021. Is there a way i can convert json code to support the latest version
Wow
Sir i tried with follwingbur same steps but showing as “there was a problem importing your theme”
Try again with new prompts
It doesnt come in one shot
@@PavanLalwani could you please give one example of “prompt”
Need how to create a data modelling in power bi
How do I wrote this file I try to login but it says in amount
How to change the white background of everychart like this
❤
Is there any projects to practice in power bi, please help so we can practice.
It's already there on RUclips
Search in Playlist
Please sir continue series
Hi pavan sir
Evening Sir,
I'm learning Power BI through your YT videos hear i have one doubt
I have 1.5 Years of carrier gap so can i expect Job as a Power BI developer.? suggest me
See my visit RUclips Live video
I'm a power bi developer. Is there a remote challenge for my job in the future
How to connect you sir
contact@pavanlalwani.com
Please start a fresh PowerBI course in HINDI 🙏
It's in post production
Will be launched soon
Keep tracking www.pavanlalwani.com
Hello Sir,
I have 3 tables in 3 different work sheets of the same work book. One is Main Data Table, 2nd is Block Names with code against each name, and the 3rd is Craft Names with codes against each name of the Craft.
The problem is that I have to add two columns (Block & Craft) to the Main Data Table on the basis of the codes which are embedded in one of the columns (Registration Number) of Main Data Table .
In Registration Number Column, the craft and block are embedded in the form of codes which are separated by delimiter dash (-)
Please write a dynamic power query code.
I will provide the list of Blocks & Crafts
The Blocks will remain only 8 in number and wouldn't change but the list of Crafts may change/increase in future. Therefore, if there is any addition in the Craft that should be automatically added.
Example of Registration Number Column:
ADHS-SFK-CPWS-01
ADHS-SHL-KS-01
ADHS-RAM-CPT-106
ADHS-SR-CRL-015
ADHS-PTH-KTS-066
ADHS-GDB-TAP-217
ADHS-SKDLA-SZ-07
ADHS-SKDLB-STP-044
In the above Registration Number column, the coding for Crafts is as undder:
CPWS= Copperware Sakhta
KS= Kani Shawl
CPT= Carpet
CRL= Crewel
KTS= Katas
TAP= Tapestry
SZ= Sozni
STP= Stapple
and the coding for Blocks are:
SFK= Safakadal
SHL= Shalimar
RAM= Rambagh
SR= Soura
PTH= Panthachowk
GDB= Gadoodbagh
SKDLA= Saidakadal-A
SKDLB= Safakadal-B
Please make a video on this....
Are you serious ?
Have you tried ChatGPT to get the answers
This is not Chat GPT with Microsoft Power BI, its creating themes using CHAT GPT.
bingo
🐈
Thank You Sir
Thank you sir