Hi,
I have a date format in a slicer like 202106 and 202405. I want to show these dates in an alphabetical way like
"June 2021 to May 2024".
I have data from the backend that starts from 1990 and ends in 2040 as a date range. When I try to select the date range if I change the minimum date it defaults to 1990 likewise with the maximum date range it defaults to 2040.
This is how it looks
I need to display the range as per my selection. can somebody help me out with this issue? Please
l am using a default two year slicer along with the period slicer.
default two year is where I am displaying data for the last two years automatically if I reset in power bi service.
I have synced the normal date slicer and this two year default slicer.
when I try to change the "To Date" it is by default showing the minimum date as below.
As in above usual date I have is 202405 in the "To Date", I have changed it to 202401.
after changing "From Date" defaulted to minimum date of my backend date from server.
Hi @Anonymous ,
Suppose we have:
Please create a new measure:
Measure = CALCULATE(MIN('Date'[Month Year]),'Date'[Year Month]=MIN('Date'[Year Month])) & "-" & CALCULATE(MIN('Date'[Month Year]),'Date'[Year Month]=MAX('Date'[Year Month]))output:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Hi,
Please help me with this issue as you have given a solution and it worked halfway through my process.
to go in detail. here's below
l am using a default two year slicer along with the period slicer.
default two year is where I am displaying data for the last two years automatically if I reset in power bi service.
I have synced the normal date slicer and this two year default slicer.
when I try to change the "To Date" it is by default showing the minimum date as below.
As in above usual date I have is 202405 in the "To Date", I have changed it to 202401.
after changing "From Date" defaulted to minimum date of my backend date from server.
Hi,
Thank you for the help. The solution you have shared helped me through halfway.
If I try to choose the range of dates in "To Date" side, the "From Date" is going to minimum value as shown below.
This is happening only when I select the "To Date".
can you help me to make it as per my selection.
is this a text box?
Try to create a table and in the values put the earlist date and latest date:
Hi,
Yes, I have used text box for that to display the selected dates.
creating a table and used the date as you have mentioned. It didn't work out.
my apologies, I might not be more specific about the issue. Let me try to explain clearly.
As I have taken a slicer(between[to be specific]) "from date" and "to date". If I try to change from date and entered a date, the "to date" automatically goes to 2040. Cause it is choosing the max date from the table .
Likewise, with the minimum date.
If I select any specific date either from or to date, I want to see the exact same dates to be displayed as the input.
Thanks in advance.
As shown in the screenshot
If I try to choose "To Date" which is 202405, currently we are in May 2024 which is the latest. It should display May 2024 instead of January 2040. Even if I choose any future dates from now, automatically it should replicate the selection which I made but, by default, it is choosing the max date which we have given at the backend level.
Likewise, the same with the "From Date". It defaults to 1990.
Also, I have made a custom date format which displays only the Year and month in the slicer.
