Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bsz412
Helper III
Helper III

Period slicer with slider, month-year format instead of default format

Hi, 

I was requested to create a date slicer which does not display day, only month and year. Slider version would be the best, or if that is not possible a separate start date end date selector would do. 

bsz412_0-1645130254800.png

What I have tried so far: 

 

- adding an additional column with the required Month-Year (e.g Jan-2022) format to my calendar lookup table. This is handled as a text, so if I put it on a slicer only list and dropdown options are available, not the "between" option with a slider.

 

- If I add only the year or only a month as a number it works, but if I handle year and month separately then I end up with 2 slicers which is a bit too much. Maybe if the month could be changed to text format and keep the slider somehow that could be acceptable if there is no other option

 

bsz412_1-1645130637838.png

 

- Month-year format as a dropdown, but it is not what the client wants

 

- the timeline slicer: too big, not accepted by the client

 

I saw some solutions where start and end date was on two different slicers, and then this had to be added as a filter function to the DAX measures. Sales Between Date rage DAX filter | Power BI Exchange (pbiusergroup.com)

My concern with these kind of solutions is that for each and every DAX measure I want to filter by date I will have to add these filter condition as part of the DAX code, if I got the concept right. I find that too complicated and I want to avoid such complications. I am not sure if there is a simple solution for this issue. 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @bsz412 

 

A more usual month year format is what they want, eg. Jan21, or Jan-2021, sthg like that....

As far as I know, this cannot be done. Range slicers can only work on date or number types.
One option is to use two slicers acting together as mentioned in your question.
The other option is what @TheoC  mentioned above.

 

Unfortunately, you can't use text formatting in a range slicer.

Use the numeric range slicer in Power BI

 

Your demand is a good idea, while it is not supported to implement in Power BI currently.

You can vote up a idea or submit a idea to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future

 

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng

 

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

View solution in original post

6 REPLIES 6
Gshepo84
New Member

I layered 2 cards over the slicer. You could do this with any desired format.

MAXPERIOD = MAX(_MasterPeriods[Period])
MINPERIOD = MIN(_MasterPeriods[Period])
 
Screenshot 2024-07-18 102201.png
 
v-angzheng-msft
Community Support
Community Support

Hi, @bsz412 

 

A more usual month year format is what they want, eg. Jan21, or Jan-2021, sthg like that....

As far as I know, this cannot be done. Range slicers can only work on date or number types.
One option is to use two slicers acting together as mentioned in your question.
The other option is what @TheoC  mentioned above.

 

Unfortunately, you can't use text formatting in a range slicer.

Use the numeric range slicer in Power BI

 

Your demand is a good idea, while it is not supported to implement in Power BI currently.

You can vote up a idea or submit a idea to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future

 

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng

 

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

TheoC
Super User
Super User

Hi @bsz412 

 

Can you have your slicer as YYYYMM (i.e. Year and Month) like below?

TheoC_0-1645135729826.png

Hope this works for your client?

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Hi this is a nice idea but the issue here is that it generate unwanted value like 201422 / 201423 / 201424 / .... etc.... which in a date context YYYYMM do not exist

@PierreL69 you're right. Unfortunately, this looks to be a glitch as it should only be considering the values in the field, not those that do not exist.  Good pick up and apologies this didn't work appropriately.

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Thanks for sharing this idea. A more usual month year format is what they want, eg. Jan21, or Jan-2021, sthg like that....

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.