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!!
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)
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..
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..
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
thanks for helping with these specialized contributions, highly appreciated
Excellent job
#LOVED the Sales Overview/Outline/Analysis ...
Great stuff
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)
Hope I'll learn the new stuff 😊
Sir ur projects are really helpful i'm learning a lot from it
Glad to hear that
Please do a comprehensive video on the most frequently used dax functions especially for e-commerce and health domain. Thank you.
Please make Dedicated Videos on Power Query and DAX Functions
Could you prepare some Inventory Project?
How should I modify the Sales by State and Profit by State' data or visualizations
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!!
Great content. My map isn't displaying. What could be the issue please?
FYI For the west region bar chart filter was not selected for West
Sir is there any chance you will upload that Election Power Bi Dashboard in the upcoming videos??
please make a video on retail sales
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)
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..
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..
Can u please do project on health domain
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
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 I want to purchase power BI project. Please send me link
topmate.io/data_tutorials/