Compare any week/Year using 2 Slicers as input in PowerBI | MiTutorials

[@feldy31683]

This is was awesome! Thank you for putting this video together. This is useful for being able to compare different prices and sales in a table, instead of just comparing vs prior year

[@MITutorials]

Glad it was helpful!

[@b0rme]

This is genius and EXACTLY what I was looking for. Thank you

[@zamvorga]

Thanks for your clear explanation. Really useful insight you have shared. Well done!

[@MITutorials]

You're very welcome!

[@zamvorga]

@@MITutorials I hope you will continue posting more soon. Thanks again.

[@147parag]

This is amazing, thanks a lot! :) One question, I'm also trying to calculate the % difference between the two sales metrics and try to show it as a card separately. I'm struggling with the formula for it. Have you done something similar?

[@warrentso2548]

Thank you for the tutorial. Is it a must to have a calendar table? Can I use the date & week & month information in the sales data? As my calendar is quite unique which do not follow the traditional one. thanks!

[@MITutorials]

It is good to have a calendar table but not mandatory.

[@warrentso2548]

@@MITutorials Does this method work on Excel Power Pivot too? Thank you!

[@khyativyas8004]

Thanks for sharing this video, I have a matrix table where we have calculation group measures as rows and different performance indexes like NSV, Gross Margin etc as columns, I need to create a dynamic slicer that picks base year and base version (Actual, budget & forecast) and comparison year and comparison version. User can select base year and version and compare against comparison year and version. I tried this method but it didn't work. I am suspicious that it might have to do something with calculation groups

[@Annatorres-l8s]

This was very useful. How do I do this if I have a scatter chart instead of a bar chart?

[@ivysangel6571]

Hello, thank you for this amazing tutorial. I am just caught up when I’m comparing year vs year. If the current year is not yet full year (meaning I can only use YTD), the comparison year is not reflecting the ytd but rather the full year. I want to see the comparison year reflect the ytd only. Can you help me?

[@ketangediya5828]

This is very helpful. I would like to know how to calculate the difference between two periods. For example, if the sales for the current month are $200 and for the previous month are $150, then the difference would be $50. How can I do this using your method?

[@bernardbernard9542]

This was very helpful, thank you !! When I try to add something on the X axis, like a type or nature, from the same table or another table linked to it, it just show the same total in every category. Any idea on how to fix that ? Is it doable ? Thank for your help :)

[@SHS-8]

Superb.. Thanks for the video

[@emiliaemilia4489]

Hi! Can you do this to compare 3 or 4 years? I tried and I can't seem to make it work. I would really appreciate if you could help. Thanks

[@devtriv]

Great! What formula does the Total Sales measure have? Thanks.

[@MITutorials]

It is - calculate(sum(Sales))

[@amitsrivastava28]

can we do it with single Slicer, also for multiple year, i.e. if user selected three years say 2017, 2019 and 2021 in a single slicer and comparison will be based on these year selected in single slicer only.

[@MITutorials]

You can create a column chart and add Year to the Legend and Category to the X Axis and create a slicer to select the years to compare.

[@Littledino123]

Legend! thank you for your helpful content 👌👏

[@MITutorials]

Any time!

[@mohammedimran5269]

Can you tell me how to find the variance of the two dates selected in Dax?

[@thenmozhiarul4391]

@MITutorials : thank you so much for this video., this really resolved my issue., could you please help me with the calculation between this 2 dates selected in slicer

[@doddybayu]

Hi, thank you so much for creating this content. Im trying to do create relation with the calendar table. However when trying to create the matrix, the date shows blank. When before if i dont put relationship, it's fine. Is there any step i missed?

[@MITutorials]

This video should answer your question. kzbin.info/www/bejne/hZinYYGggMqKerc

[@PujaSingh-cy8kx]

My bookmark navigation button is not working Stiil I ned to change the view from Boomark pane only .could you please suggest If am mistaken somewhee.

[@analyticsadda6080]

This is good but I also want to show month name in x axis to selected month in graph how this is possible ?

[@junedahmed1469]

Awesome video bro. I just have one question though. When I import my dataset in power bi, it automatically gives me a hierarchy that has month, quarter and year. But after creating a comparison calendar, I see that my main date table loses hierarchy. It just has “Date” option. But comparison table has the hierarchy. I want to compare monthly, yearly, quarterly. Why do my main date table loses hierarchies after creating a relationship with comparison table? Before creating a comparison calendar, I can pick quarter and month, year from my main table. But when I create a comparison calendar for comparing, my main date table doesn’t give me quarter, year or months. It just give me Date like 23 March, 2020. I want it to give me like year, quarter and month. So that I can pick any quarter easily, instead of clicking each month individually

[@MITutorials]

When you create relationship with Calendar table you must use the date field from the calendar table and measures from the fact table.

[@junedahmed1469]

Oh hi. Now I got you bro. you saved me. Thank you so much. Appreciate it!

[@junedahmed1469]

Last question brother. I am creating a dashboard for my company. So my main date table ranges from 2019 January to 2023 July. I created the calendar using DAX functions: Calendar (Date(2019,1,1) Date(2023,1,7) like this. Now I want to send my dashboard end of each month to some members of my company. When I will update my excel sheet after pulling data for August 2023 and refresh my dashboard, will my created calendar work or not? I fixed it till July 2023, right. In this case, what should I do?

[@dhruvkapoor767]

How can we show variance between dates selected in two slicer or in two diff slicer

[@analyticsadda6080]

This is not working in stacked column chart I am not able to put category in legend

[@junedahmed1469]

Hey bro, how can I compare total revenue vs selected site revenue? For example, I have a company that has 23 locations. In the data set my first column represents locations name, second column represents revenue number. I want to create a line chart that shows two different lines. One line is for the whole company revenue vs another line for the selected location. How can I do that?

[@MITutorials]

On the X axis you want months ?

[@pari-zaad]

Excellent

[@ChrisSmithFW]

This is great but unfortunately doesn't work in all use cases. When in an enterprise environment with live connect to Azure DevOps, developers don't have the ability to create additional tables.

[@revathinarayanan9304]

Great

[@nossamusik]

How to select only one option in two different filters? example: In Filttro 1 it has the options (A, B ,C) and in Filttro 2 it has the options (D,E,F). So, how to select only 1 option among all options (A,B,C,D,E,F)?

[@MITutorials]

These 2 slicers are from 2 different tables ?

[@nossamusik]

@@MITutorials Yes, it's the same table, I can send you the files in your email for you to check, because I couldn't solve this problem. What is your email?

[@MITutorials]

[e-mail]

[@nossamusik]

@@MITutorials I sent it to your email with the subject: Doubt filters

[@MITutorials]

Dropping the Tutorial on 7th Oct at 10:00 AM IST

[@ChiragKaushik-f4k]

where is this data-set?

[@dineshmalla4556]

If I use one slicer the other slicer should not be work and vice versa how to do plzz.reply

[@MITutorials]

I will make a tutorial on this soon.

[@mangeshveer9708]

Great