Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have date field in my data model. I have kept that date field at UI as a slicer. But when click on year it shows those years also which are not there in date field . eg 2009 , 2010, 2022. Why is that so?
Please suggest solutions.
Regards
Vaishali
Solved! Go to Solution.
@Vaishali04 That's a default behavior of Date Slicer. It will show up all the year irrepective of your Date's date.
One workaround is that you can split the Day, Month, and Year in individual slicer. Like I did for Year so it will only show as per your data available in Date table.
Year = YEAR(Calendar[DateColumn])
Likewise create for Month and Day.
@Vaishali04 That's a default behavior of Date Slicer. It will show up all the year irrepective of your Date's date.
One workaround is that you can split the Day, Month, and Year in individual slicer. Like I did for Year so it will only show as per your data available in Date table.
Year = YEAR(Calendar[DateColumn])
Likewise create for Month and Day.
@Vaishali04 , This happens with the Date Range slicer, know behavior.
You can check or log an idea -https://ideas.powerbi.com/ideas/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |