Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
215 | |
89 | |
76 | |
66 | |
60 |