Date Slicer without relationships

[Riley-Byrne]

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

[v-frfei-msft]

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 · Accepted solution]

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. 

[parry2k]

@Riley-Byrne glad to hear you have solution. cheers!!

[parry2k]

@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.