Forum Discussion

nandvroe's avatar
nandvroe
Frequent Visitor
8 years ago
Solved

Date Slicer control two visualizations

I have a two date slicers  based on a calendar table one for Fiscal Month and one for Fiscal Year.  These slicers control two visuals based upon two different tables Invoice Lines and Sales Order Lin...
  • nandvroe's avatar
    nandvroe
    8 years ago

    shebr

     

    I can't believe this!  I went back to get the data you requested and suddenly the measure I'd been working with started working.  I don't know why it suddenly started giving me the expected results (I've been working with it since last Thursday).  The only thing I can think of is that I deleted and recreated one of the relationships.

     

    Anyway, I'm listing the solution below and marking this as solved.

     

    SOMeasure1 = If(Max('Sales Order Lines'[Created date])>LastDate(CalendarTbl[Date]),0,1)

     

    I added the above measure to my table and applied filter is "1".  Set "Edit Interactions" to filter all the page vizualiztions.

     

    Thanks to all for the help!  Much appreciated!

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi nandvroe,

 

Could you please attach some screenshots highlighting your problem. Visualizing helps :)

  • nandvroe's avatar
    nandvroe
    Frequent Visitor
    8 years ago

    ssobti,

    Thank you for your response.  Below is a screen shot using sample data.  Notice the date filter is controling the chart and cards, but not the two tables below.  I have selected the month of March in the date filter. My goal in the two tables below is to show everything prior to March.  In other words the items with April dates should not show.  Right now I have "edit interactions" set to not filter the two tables.  

    Hope my screen shot helps explain what I hope to accomplish.

    Thank you for your time.