Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I have a scenario wherein the selected value in the slicer has to be the current month and previous month. For example, if the users are checking currently, Sep 2020 and Aug 2020 has to be the default selections. In the next month, it has to be Oct 2020 and Sep 2020.
The below displayed is the data for reference.
Month | Sales |
Jan-20 | $1,346,931 |
Feb-20 | $242,824 |
Mar-20 | $1,543,120 |
Apr-20 | $286,320 |
May-20 | $1,296,335 |
Jun-20 | $1,991,486 |
Jul-20 | $1,237,445 |
Aug-20 | $680,516 |
Sep-20 | $1,284,505 |
Thanks for the help!
@Arunraj89 , In you date table you need to have a column like this and select "Last 2 Months". Month year is column you already have for month year
Month Type = Switch( True(),
Date([Date]) >= eomonth(Today(),-2)+1 && Date([Date])<= eomonth(Today(),0),"Last 2 Months" ,
[Month Year]
)
Thank Amit! But, the client wants to see the name of months in Slicer. If i use the solution that you gave, i will be seeing "Last two months" and name of other months as items in the slicer. @amitchandak
hi @Arunraj89 - There is no out of the box feature in Power BI to automatically set the latest month in a date slicer.
You would need to follow the approach of creating a calculated column with a value like "Current month" or "Last 2 months" and setup the report as seen in the below video:
https://www.youtube.com/watch?v=pCgK-Ze3nhA
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
@Arunraj89 , I doubt having an option like that.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |