Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Relevant values for Disconnected tables

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

 

Filter Dates =
VAR StartDate = SELECTEDVALUE('Disc Start Date'[Start Date])
VAR EndDate = SELECTEDVALUE('Disc End Date'[End Date])
VAR SummaryDate = MAX('Table1'[Calendar Date])

 

RETURN
IF ( SummaryDate >= StartDate && SummaryDate <= EndDate, 1, BLANK())

 

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

 

 

 

 

Need Help
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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