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?
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.
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
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.
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 : 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
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!
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?
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 :)
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?
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
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?
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
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 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?
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?
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
Superb.. Thanks for the video
This is good but I also want to show month name in x axis to selected month in graph how this is possible ?
Can you tell me how to find the variance of the two dates selected in Dax?
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.
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.
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
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.
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.
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?
On the X axis you want months ?
@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
This is not working in stacked column chart I am not able to put category in legend
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!
It is good to have a calendar table but not mandatory.
@@MITutorials Does this method work on Excel Power Pivot too? Thank you!
How can we show variance between dates selected in two slicer or in two diff slicer
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?
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 :)
Excellent
Thanks for your clear explanation. Really useful insight you have shared. Well done!
You're very welcome!
@@MITutorials I hope you will continue posting more soon. Thanks again.
This was very useful. How do I do this if I have a scatter chart instead of a bar chart?
Great! What formula does the Total Sales measure have? Thanks.
It is - calculate(sum(Sales))
This is genius and EXACTLY what I was looking for. Thank you
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?
This video should answer your question.
ua-cam.com/video/OgD0NjKeWDU/v-deo.html
where is this data-set?
Great
If I use one slicer the other slicer should not be work and vice versa
how to do plzz.reply
I will make a tutorial on this soon.
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
When you create relationship with Calendar table you must use the date field from the calendar table and measures from the fact table.
Oh hi. Now I got you bro. you saved me. Thank you so much. Appreciate it!
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?
Great
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
Glad it was helpful!
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)?
These 2 slicers are from 2 different tables ?
@@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?
Mitutorials08@gmail.com
@@MITutorials I sent it to your email with the subject: Doubt filters
Dropping the Tutorial on 7th Oct at 10:00 AM IST
Legend! thank you for your helpful content 👌👏
Any time!