Compare any 2 years data Power BI | Power BI tutorial

In this video we learn how to compare any 2 year's data or any month's data in Power BI.
Below is the link to get the report

#powerbi
#bi
#bitips
#powerbidesktop
#dax
#daxquery
#allfunction
#all
#userelationship
#duplicatetable
#powerbiforbeginners

[CurioClipsEN]

That’s exactly what I was looking for! Perfect simple explanation!! Thanks a lot!!!

[unnikrishnansanthosh]

really impressed with your crystal clear explanations, thanks for sharing

[rakeshmahakud]

Finally got the solution looking for more than a week. Thanks for your efforts.

[vsrinivasan]

Good, you are creating interest in us to learn Power Bi, Thanks

[rajad]

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.

[yemensport]

I really was waiting for such a video.
I appreciate.

[bangaramgayathri]

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 🎉

[srinivaschakravarthi]

Hello mam,
The way you explaining is awesome and easy to understand mam...

[YousufKhan-vgni]

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

[aldoramonteiro]

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.

[Riek]

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?

[yasararafathmohamed]

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?

[muhammadatiq-ur-rehman]

Hi ! Thanks how we can compare dates range like pre date ranger vs post date ranges ?

[allenroberts]

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

[anaisgarnier]

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? :)

[dinesharivalagan]

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?

[cecilmathew]

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 .

[gopalakrishna]

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.

[nageswarreddy]

Thank u mam.explaining this.can u please explain difference in timings

[areebairfan]

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?