Hi Swapnjeet ,for the Last grid to add No data I have tried this PY Sales = VAR SelectedYear = SELECTEDVALUE('Calender Table'[Year]) VAR PreviousYearSales = CALCULATE([Total Sales], 'Calender Table'[Year] = SelectedYear - 1) RETURN IF(ISBLANK(PreviousYearSales), "No Data", PreviousYearSales)
Hi Swapnjeet, Your all videos are really very helpful and I really appreciate your dedication. One thing I want to ask that, Can you tell me that where is the "Add further analyses to your visual" in latest version of Power BI. As I updated a latest version of it, but couldn't able to find it. If possible please let me know ASAP. Thank you so much for your very helpful learning videos. Thank a lot!!
Hello sir, i am getting an issue ..actually i am not getting this option of (Add Further Analyses to Your Visual) in my build pane? How to cope this issue please guide..
Why can't I use map in Power BI. I am told to contact tenant admin even though there is no tenant admin for me. I tried to enable the maps in settings, it worked for some minutes and went back to no visuals
Great content, Swapnjeet S! As you mentioned, I’ve created a dynamic title for the map using our custom measure, which aligns precisely with your request. Dynamic map Title = MAX(metrics[metrics]) select map visual > format > title > fx section > select the measure which you have created in What field should we base this on > ok
@@datatutorials1 Yes, I'm familiar with that.... I've already worked on some calculations using DAX, but I encountered some errors, and despite troubleshooting, I haven't yet resolved them completely. I’m still working on it, but I would really appreciate any suggestions you might have to help me move forward. thankyou..
For displaying No data to the table I tried below but it's not working PY Sales = VAR SelectedYear = SELECTEDVALUE('Calendar'[Year]) VAR PYSales = CALCULATE('Sales Data'[Total Sales],'Calendar'[Year] = SelectedYear - 1) RETURN IF(ISBLANK(PYSales),"No Data",PYSales)
Thank you for this video. I don't know what I am doing wrong, but my PY KPI Sales is not giving me the same figure as yours. For example, the sales for 2024 PY KPI is giving me 609.86k. Where could the issue be coming from please?
I Know this wrong method but i did this in this way first I rename title of name from "sales by state " to "by sales" then i just copy the dynamic title measure then paste just before the title of map . it working
Second method is create a mesaure name of dynamicMapTitle = "State by " &SELECTVALUE MAX('Select Matric'[Select Matric]) then put this mesaure in the map title fx section and select this measure then it show dynamic title
Awesome. Let's dial the difficulty up and do a very challenging project.
I sincerely appreciate you for walking us through projects like this. Thank you.
Please do power query and dax functions full video which are used in realtime mostly
#LOVED the Sales Overview/Outline/Analysis ...
Excellent job
Sir ur projects are really helpful i'm learning a lot from it
Glad to hear that
thanks for helping with these specialized contributions, highly appreciated
Thank you very much for your work. its very clear .
Appreciate every bit of detail🔥💯
Hope I'll learn the new stuff 😊
Great stuff
Great stuff
I learned many things in short period of time ❤
Awesome tutorial. Try to shorten it though so that you get more viewers bc people are lazy these days.
Thank You!
Please do a comprehensive video on the most frequently used dax functions especially for e-commerce and health domain. Thank you.
Hey buddy, you're fantastic!👏
Hi Swapnjeet ,for the Last grid to add No data I have tried this
PY Sales =
VAR SelectedYear = SELECTEDVALUE('Calender Table'[Year])
VAR PreviousYearSales = CALCULATE([Total Sales], 'Calender Table'[Year] = SelectedYear - 1)
RETURN
IF(ISBLANK(PreviousYearSales), "No Data", PreviousYearSales)
Hi Swapnjeet,
Your all videos are really very helpful and I really appreciate your dedication.
One thing I want to ask that, Can you tell me that where is the "Add further analyses to your visual" in latest version of Power BI. As I updated a latest version of it, but couldn't able to find it. If possible please let me know ASAP.
Thank you so much for your very helpful learning videos. Thank a lot!!
Thanks you, just one thing in each KPI, PY sales only showing for all 3 metrics, it should change right
can you please do a vedio on advanced dax formulas report,it will be most helpfull
Please make Dedicated Videos on Power Query and DAX Functions
please make a video on retail sales
For more Power BI projects - www.youtube.com/@ChandanKanuOfficial
FYI For the west region bar chart filter was not selected for West
Thanks a lot
please answer the dynamic title thing
Will u teach web scrapping
How should I modify the Sales by State and Profit by State' data or visualizations
Hello sir, i am getting an issue ..actually i am not getting this option of (Add Further Analyses to Your Visual) in my build pane? How to cope this issue please guide..
Hey
In west region you don't change the bar chart to filters condition from south to west
Could you prepare some Inventory Project?
Great content. My map isn't displaying. What could be the issue please?
what kind of sales bro this is ? name of the sale project ?
I am Not able to add State and Province data in my map.
Why can't I use map in Power BI. I am told to contact tenant admin even though there is no tenant admin for me. I tried to enable the maps in settings, it worked for some minutes and went back to no visuals
Can u please do project on health domain
I tried to buy one course using the coupon Diwali but it says code has expired or does not exist. Pls advise
should be in full caps DIWALI I think ?
Sir is there any chance you will upload that Election Power Bi Dashboard in the upcoming videos??
Sir plzz make that Election Power Bi project it would be very helpful for us
Great content, Swapnjeet S! As you mentioned, I’ve created a dynamic title for the map using our custom measure, which aligns precisely with your request.
Dynamic map Title = MAX(metrics[metrics])
select map visual > format > title > fx section > select the measure which you have created in What field should we base this on > ok
I had the same solution :)
@lkn-iw1my nice
Great job, what about last grid to add No Data
@@datatutorials1 Yes, I'm familiar with that.... I've already worked on some calculations using DAX, but I encountered some errors, and despite troubleshooting, I haven't yet resolved them completely. I’m still working on it, but I would really appreciate any suggestions you might have to help me move forward.
thankyou..
Done?@@revalladhanunjay8690
For displaying No data to the table I tried below but it's not working
PY Sales =
VAR SelectedYear = SELECTEDVALUE('Calendar'[Year])
VAR PYSales = CALCULATE('Sales Data'[Total Sales],'Calendar'[Year] = SelectedYear - 1)
RETURN IF(ISBLANK(PYSales),"No Data",PYSales)
Sir still I'm waiting for that Election Dashboard will it be uploaded? it was a really nice Project
Thank you for this video. I don't know what I am doing wrong, but my PY KPI Sales is not giving me the same figure as yours. For example, the sales for 2024 PY KPI is giving me 609.86k. Where could the issue be coming from please?
Could U please tell from which reagion....U R getting 609.86K?
@@revalladhanunjay8690 I have figured it out. I didn't filter the region before but I figured it out now and everything is fine. Thank you.
could you plz explain how to change the title "sales by state" dynamically
Did you try first and what approach dod you follow
@@datatutorials1 please tell us
I Know this wrong method but i did this in this way
first I rename title of name from "sales by state " to "by sales" then i just copy the dynamic title measure then paste just before the title of map . it working
Second method is create a mesaure name of dynamicMapTitle = "State by " &SELECTVALUE MAX('Select Matric'[Select Matric])
then put this mesaure in the map title fx section and select this measure then it show dynamic title
Create measure Max( Select Metric{Select Metric}) & " by State"
Then in title function add this measure
upload the PYTHON tutorial please
Sir I want to purchase power BI project. Please send me link
topmate.io/data_tutorials/