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!

     

     

  • nandvroe's avatar
    nandvroe
    Frequent Visitor
    8 years ago

    shebr,

     

    Thank you.  This is some great information, but unfortunately I don't think it will resolve my current issue.  I've actually tried this method, but it still didn't give me the results I needed.  I am so new to PBI however, it's very possible I did something wrong.

     

    • shebr's avatar
      shebr
      Resolver III
      8 years ago

      Hi nandvroe,

       

      Do you want to share some details of your data set, relationships and DAX measures you've used? I can try look at this for you, just tell me (visually) what results you are getting and what you are expecting.

       

      Thanks

       

       

      • nandvroe's avatar
        nandvroe
        Frequent Visitor
        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!