In slicer format pane we have three options are there single-select,multi-select,select all. As per requirement I understand easy way too do that. Create a visual and bring the total sales,year put on the visual. After that enable the multi select feature and select any years in slicer then appears two years data here.
Seems simple, but my data have already assigned datetime and do not have separate Calendar. Would there be better way of doing it without having separate Calendar table?
Hi week over week is an important topic. So i will cover it in tge next video and include the file so it can be useful to many. Thank you for suggesting the topic
Hi there, in conditional formatting, how can we compare one cell to another cell? So for example I want to highlight a cell, if the number of another cell is the same as the first cell. If it is lower or greater than the second sell, it should have another color.
My data is time series data, and I am using a line chart. However, I used the average function the calculate function, because POWERBI said that I need to have a aggregate function. I'm getting same value for all time periods, as it's calculating average of entire period, and giving out same value for every datestamp
Hi! thanks for your video. Although the compare year doesn't react when we click on other parts of the report for example if I click on January then my regular amount will change to display only the amount of Janurary while the compare colomn still shows the full year. Do you know how this compare year can exist and still be responsive? :)
Good explanation. I want two years comparison based on single year selection and need to show the year dynamically in x axis. If I select 2020 in slicer, I want to show 2020 sales and 2019 sales, with the year 2020, 2019 in x axis. How to do this?
Hi! thanks for your video. it's really helpful but what I want is that, when I select more than two years in targeted slicer then it will break that green bar into two years means it will display 2 years of data in one bar. is that possible?
Thanks a lot it helped. However When I visualize by month, all the month values return the same as the Sum of the month ..meaning all the month rows have the same value. Any suggestions to get by month ? Thanks
can you plz do on a video of LTM last twelve month data in dax .. means if we click 2005 march month it have to show the 2004 april to 2005 march. and if we click 2006 nov then the (last 12 months mean 2005-december to 2006-november)
I just had an opportunity to see this video and really helpful sister .. thank you.. but i have an another scenario that the 2 bar (Compare previous year) should show with 1 slicer .. i have 1 slicer and 1 clustered chart , if i click Oct 2020 in slicer then the cluster chart should give data for Oct 2020 and Oct 2021 .. can you help me on this scenario?
Madam, is it possible to user select like this? Allows user to select different day range, see below. Also allow user to select either Compare to Previous Period, or Previous Year.
Hi mam, your videos are much understandable. this is a new measure previous year sales= calculate('FactInternetsales' [Total sales], DATEADD('calender'[date],-1,year)) after this, if you put year slicer, it will not only shows the previous year sales generated and you can select the year from year slicer whatever year that you want. then it will easy right?
yes...but margin is for only one previous year..which is present in dax..but method used in video is more dynamic... thank you for such a nice explanation Hima
But why if there are more than 2 year than sameperiodlastyear function gives incorrect value? And if there are only 2 year like 2019 and 2020 then it gives correct value.
Pls do video for last 3 months sales with respective selected data . Actually if i selected date in calendar date it shows only that month sales trend pls do video
![CAMPปลิ้น | รวม Highlight 2024! PART [1/2]](http://i.ytimg.com/vi/6hnvNnvYloU/mqdefault.jpg)
That’s exactly what I was looking for! Perfect simple explanation!! Thanks a lot!!!
really impressed with your crystal clear explanations, thanks for sharing
Finally got the solution looking for more than a week. Thanks for your efforts.
Thank you !
Good, you are creating interest in us to learn Power Bi, Thanks
Hello everyone, I couldn't found that fields option in power bi dashboard
Please anyone help
Really good one 🙏🙏👍👍👍👍
You are a very good trainer. Thanks
Thank you
I really was waiting for such a video.
I appreciate.
Awesome videos....all doubts are cleared y All function is used one of best example to learn dax functions in real-time..keep doing such videos 🎉
Thank you 🙂
Thank you 🙏🏻❤
In slicer format pane we have three options are there single-select,multi-select,select all. As per requirement I understand easy way too do that. Create a visual and bring the total sales,year put on the visual. After that enable the multi select feature and select any years in slicer then appears two years data here.
Thank you, great tutorial
Excellent
Seems simple, but my data have already assigned datetime and do not have separate Calendar. Would there be better way of doing it without having separate Calendar table?
Hello mam,
The way you explaining is awesome and easy to understand mam...
Thank you !
Could you pls show the dax for last week and current week sales please mam
Ok I will post the sample file here
@@TheHimaBindu thank you mam
Hi week over week is an important topic. So i will cover it in tge next video and include the file so it can be useful to many. Thank you for suggesting the topic
finished watching
Awesome
Hi there, in conditional formatting, how can we compare one cell to another cell? So for example I want to highlight a cell, if the number of another cell is the same as the first cell. If it is lower or greater than the second sell, it should have another color.
Good
My data is time series data, and I am using a line chart. However, I used the average function the calculate function, because POWERBI said that I need to have a aggregate function. I'm getting same value for all time periods, as it's calculating average of entire period, and giving out same value for every datestamp
Great... keep going.
How do I compare 2 years/month data i.e. year 2018 data with 2021 data having multiple datasets on single page? If there is a solution please reply .
Hi! thanks for your video. Although the compare year doesn't react when we click on other parts of the report for example if I click on January then my regular amount will change to display only the amount of Janurary while the compare colomn still shows the full year. Do you know how this compare year can exist and still be responsive? :)
Good explanation. I want two years comparison based on single year selection and need to show the year dynamically in x axis. If I select 2020 in slicer, I want to show 2020 sales and 2019 sales, with the year 2020, 2019 in x axis. How to do this?
Thank you very much
Hi! thanks for your video. it's really helpful but what I want is that, when I select more than two years in targeted slicer then it will break that green bar into two years means it will display 2 years of data in one bar. is that possible?
Thank you
Thanks a lot it helped. However When I visualize by month, all the month values return the same as the Sum of the month ..meaning all the month rows have the same value. Any suggestions to get by month ? Thanks
Have you found solution?
Hi ! Thanks how we can compare dates range like pre date ranger vs post date ranges ?
can you plz do on a video of LTM last twelve month data in dax ..
means if we click 2005 march month it have to show the 2004 april to 2005 march.
and if we click 2006 nov then the (last 12 months mean 2005-december to 2006-november)
I just had an opportunity to see this video and really helpful sister .. thank you.. but i have an another scenario that the 2 bar (Compare previous year) should show with 1 slicer .. i have 1 slicer and 1 clustered chart , if i click Oct 2020 in slicer then the cluster chart should give data for Oct 2020 and Oct 2021 .. can you help me on this scenario?
Excellent tutorial to use two slicers in same table. Can u pls explain how to find variance between any two years? Thanks.
Will make a video 👍
@@TheHimaBindu Looking forward to it. Thank u very much.
Hi, can we use the same dax as modifed for month and week?
Thank u mam.explaining this.can u please explain difference in timings
Will do
Madam, is it possible to user select like this?
Allows user to select different day range, see below. Also allow user to select either Compare to Previous Period, or Previous Year.
how to compare specific year particular month with another year particular month (Ex: March 2020 v/s March 2022). Please help me
Hi mam, your videos are much understandable.
this is a new measure
previous year sales= calculate('FactInternetsales' [Total sales], DATEADD('calender'[date],-1,year))
after this, if you put year slicer, it will not only shows the previous year sales generated and you can select the year from year slicer whatever year that you want. then it will easy right?
Thats right. What ever year you select in the slicer you get the measure value changed for previous year
yes...but margin is for only one previous year..which is present in dax..but method used in video is more dynamic... thank you for such a nice explanation Hima
But why if there are more than 2 year than sameperiodlastyear function gives incorrect value? And if there are only 2 year like 2019 and 2020 then it gives correct value.
Pls do video for last 3 months sales with respective selected data . Actually if i selected date in calendar date it shows only that month sales trend pls do video
Hi mam thnks for this infrmtn, one small doubt among joins which join is not prefrble and y
Hi. Joins depend on your data. If you want only matching records then inner join is the best option
Really informative, plz could you help me to include a trend line on top of the comparison.tried all possibilities unfortunately i failed 😊
Hi . Sure. I can send you a sample file. I am a li'l busy this week and next week . Will try to send you by end of next week
pleae provide your dataset for practice.
Hi mam, do vedios on interview point of view?
Ok
Plz bring a series on mtd ytd pytd qtd in dax and in slicer
Will do
sunilmotwani
Mam, can zoom in plse
Looks like a Carbon copy of Agile Analytics Video