Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI desktop

Hi, I wanted to add a YearMonth slicer in my report which will show the data till the Previous month only. And by default, all these YearMonths should be selected. To show the values till the Previo...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks Anonymous for quick response!

    So, in the dropdown slicer visual also it should automatically appear as "Selected" right?

  • olgad's avatar
    olgad
    3 years ago

    In the dropdown slicer that you displayed in your screenshot, you are going to have 2023/07 provided you have that month in your date table or generally in the table feeding that slicer.
    However, you cannot keep it selected, for that you need to have a general description like "Current Month"  so it stays selected from month to month irrespective which month it is.  If your requirement to have " select all " like you have in the screenshot then yes, it will also be selected.

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

In the dropdown slicer that you displayed in your screenshot, you are going to have 2023/07 provided you have that month in your date table or generally in the table feeding that slicer.
However, you cannot keep it selected, for that you need to have a general description like "Current Month"  so it stays selected from month to month irrespective which month it is.  If your requirement to have " select all " like you have in the screenshot then yes, it will also be selected.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Okay olgad ! And there is one quick query regarding the same requirement. So, is it possible to have a "Between" date slicer for values with formats like "YYYY/MM". 

For example, we can have the Between range Date slicer for these date:-

 

Can we have the same but for different date format. I don't believe it is possible in power bi.