Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
We have created disconnected tables for start and end dates. we are using them to display data between the start and end date ranges when they are selected in slicer.
This works fine using below formula
I want to make the start and end dates show relavent value in slicer based on any other slicer selection
Is there a way to do that please suggest.
Thanks in advance
@praveenpasila , do you need something like
Date Range Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Date])
var _min = maxx(allselected(Date2), Date2[Date])
return
calculate(countrows(Table), Filter(Table,Table[Date] <=_max && Table[Date] >=_min) )
if needed refer similar example
Select data between months - https://youtu.be/nEt7dT3Tfv4
Hi @amitchandak ,
Tried the measure but it is not working.
may be I confused the forum just to make sure we have more clarification adding screen shots below please find below
Selecting the date slicers and other slicer such as "Code" the data is displaying fine in all the charts.
But when a specific "Code" is selected the date slicers are not showing relavent values its showing all dates from the respective disconnected tables
Can we make them show only relavent values and not all dates from the Disc tables
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |