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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Austen229022
Helper I
Helper I

Slicer not taking full dates

I have a slicer that is dated MMM yy eg: Feb 23, which has all the dates from the past 12 months

 

What I am needing it to do is filter everything that is within that month as records are by the date received (eg: 14/02/2023). Currently it is only bringing up the values from the first of the month as the date data shows it as 01/02/2023.

 

How can I get it so that when I select a month in the slicer that it will show all the data for that selected month?

 

This works when I use a relative date slicer though this doesnt fit what I am needing to do

2 REPLIES 2
HotChilli
Super User
Super User

Could do with more detail to solve this.

It may be that the slicer holds dates like 1st Feb 2023 but they are formatted as MMM YY (but it still represents the 1st so it only matches with data from the 1st)

One way to solve this would be add a calculated column for Month / Year (in text form) and put that in the slicer.  Usually best practice would be to use a Date table with a 1:m relationship to the Fact table

You are correct that it holds the dates like 01 Feb 2023 which is formatted as a calculated column as "MMM yy" so it still thinks its the first of the month.

 

I use this column to try and filter the data though it only pulls the 1st of the month

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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