Forum Discussion

Alfista1997's avatar
Alfista1997
Frequent Visitor
3 years ago

Month-Year Based Data Slicing

I have a dataset that is strictly month-year information, there is no daily data availible. As such, my end users are looking to filter this data based on that month-year and would like to do between...
General Comment
Need Help
Tips and Tricks
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Alfista1997 ,

 

What kind of data do you want to filter through this slicer?

Does it contain daily data? If so, maybe you can use the Format() function and create a measure to help you filter data.

Besides,what style of slicer do you want?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Alfista1997's avatar
    Alfista1997
    Frequent Visitor
    3 years ago

    Hi v-jianboli-msft ,

     

    I'm looking to accomplish something like the first image below. My data format is month-year intervals. I've got 4/1/23, 5/1/23, 6/1/23, etc. As a result, when I use the typical "Between" slicer on my date field in Power BI (second impage below), the user must select 7/1/23 as the start date, if they accidentally selected 7/2/23, since there is no data for that, nothing would show. I'd like to try and skip having the user even select a day, just select the month and year like image one.  

     

    Ideal Slicer

     

     

    Current Slicer