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.
Hello,
I have placed date slicer. It is displaying default start date as 11/1/1899.
How to change default start date to 11/1/2017 & end date value to today.
Please help out to solve this problem.
Solved! Go to Solution.
Add a calcualted column to your date table like this.
Show = 'Date'[Date] >= DATEVALUE("11/1/2017") && 'Date'[Date] <= TODAY()
Then add that field as a filter on your slicer and set it to only show TRUE
Hi @V504942425U ,
As far as I know, calculated column will take up memory. And Power BI doesn't support us to add a measure into slicer. I suggest you to create a measure and then add this measure into the visual level filter.
Show =
VAR _DATE =
SELECTEDVALUE ( 'Table'[Date] )
RETURN
IF ( AND ( _DATE >= DATE ( 2017, 11, 1 ), _DATE <= TODAY () ), 1, 0 )
Add this measure into the visual level filter of your slicer and set it to show items when value equal to 1. Result is as below.
By Default:
Add measure into visual level filter:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @V504942425U ,
As far as I know, calculated column will take up memory. And Power BI doesn't support us to add a measure into slicer. I suggest you to create a measure and then add this measure into the visual level filter.
Show =
VAR _DATE =
SELECTEDVALUE ( 'Table'[Date] )
RETURN
IF ( AND ( _DATE >= DATE ( 2017, 11, 1 ), _DATE <= TODAY () ), 1, 0 )
Add this measure into the visual level filter of your slicer and set it to show items when value equal to 1. Result is as below.
By Default:
Add measure into visual level filter:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is the cardinality of the data that determines the amount of memory the columns takes so a True/False column will take up very little memory in the model. On my dates table, I have a column 'Is Past' that is a True/False and it uses 1.3 kb of memory.
Add a calcualted column to your date table like this.
Show = 'Date'[Date] >= DATEVALUE("11/1/2017") && 'Date'[Date] <= TODAY()
Then add that field as a filter on your slicer and set it to only show TRUE
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 |
---|---|
105 | |
104 | |
87 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |