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!