Forum Discussion

Riley-Byrne's avatar
Riley-Byrne
Frequent Visitor
7 years ago
Solved

Date Slicer without relationships

Hey everyone,

 

I'm sure this has been done already, but have not been able to find a solution on the forums. 

 

I have a desktop PBI that has multiple different tables from various data sources. The main source of my relationships is linking them by 'Item Number'. 

This allows me to be able to look through sets of information as by these specific item numbers, as they relate to one another in different visuals. This field is the one constant between all tables, and thus must be the focal point in my relationships. 

 

My challenge comes in when I try to include a date slicer. Several of my tables have date slicers, but I am unable to make relationships between them due to my existing Item Number relationships. Therefore, when I insert a date slicer, it does not filter appropriately across all visuals.

 

Does anyone know of a workaround for this? For reference, overview of my relationships are below. 

 

Thanks in advance,

Rile

Need Help
Tips and Tricks
  • Riley-Byrne's avatar
    Riley-Byrne
    7 years ago

    Hey everyone,

     

    You were right; had to make a separate table for part numbers. The other main cause of my issues was the relationships - not many to many, but by having them go only one direction. That was a huge key in this. 

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Riley-Byrne you should add seperate table for your item, similar like date. and set relationship of all your table with this new item table.

     

    add end of the day, you will have relationship of each table with item and date, but apart from item and table, these tables will not have relatinship with each other.

     

    Now change your item slicer to get item from item table and now everything will filter on date and on item as well.

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Riley-Byrne ,

     

    We can create a measure as below and make the table filtered by the measure.

     

    Measure = IF(MAX('BO'[Date]) in VALUES('Table'[Date]),1,0)

     

    Pbix as attached.

     

    • Riley-Byrne's avatar
      Riley-Byrne
      Frequent Visitor
      7 years ago

      Hey everyone,

       

      You were right; had to make a separate table for part numbers. The other main cause of my issues was the relationships - not many to many, but by having them go only one direction. That was a huge key in this.