Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Options to comvine dates

  Could we combine the dates so that it start with expanding the year, month and pick the days (like what we would expect on filter in excel). Also any options for us to directly type the date...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ，

    It's like a date hierarchy slicer. You can come to consider putting [year], [month/month name], [day] fields in the slicer field.

    Please check the pbix file.

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the suggestion but i wonder if there are an option like the below

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ，

    It's like a date hierarchy slicer. You can come to consider putting [year], [month/month name], [day] fields in the slicer field.

    Please check the pbix file.

    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