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.
Hii...
I am using slicer visual and i have transaction dates upto 18-sep-19 in my data model.how to restrict the dates in the between format of the slicer only to display the available dates..(remaining dates i.e from 19-sep should be disabled in the slicer)
Thanks
Hi,
You can create a calculated column in the Date table as below:
DateToShowFlag = VAR vMaxDate = CALCULATE( MAX( Transaction_Data[transaction_date] ), ALL( 'Calendar' ) ) RETURN IF( 'Calendar'[date] <= vMaxDate, TRUE(), FALSE() )
You can then put this column in the page level filter and set it to True.
The only catch here is, you will need to have the slider 'ON' for the slicer.
Thanks.
Hi @sarjensystems1 ,
It is not suported currently for Power BI. You can change the date range by sliding the slider below the date.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |