Slicer filter another slicer for many fact tables

[arhetyp]

Hello Everyone:)

I would kindy aprreciate your help regarding example below:

I have 5 fact tables (in practice much more).

Each of them consist of some unique columns and some similar ones like:

Data, Counry, Area and Town.

As I need to make some measures I connect the tables by indirect Data table.

My question/issue is:

I need to use slicers to filter data in all direction that means by contry, area and town.

All three slicer tables (Slicer_Country, Slicer_Area and Slicer_Town) are just simple lists (manually pasted).

The relation presented on screen above let me to filter all tables at the same time by contry, area and town but these 3 slicers are working separately - there is no interaction beetween them in the way: when USA is chosen I see can choose areas and towns from other countries and so on.

I have tried to change connection into both cross filter directions but it is usually blocked as imposible action.

Can you please advise me how to organize these fact tables/indirect tables to achieve tables connection as well as both direction slicers filtering at the same time?

I will appreciate all suggestions:)

Regards,

Arek

[arhetyp]

I will appreciate your help:)

[arhetyp]

Really nobody is able to help me?

Regards,

Arek

[Anonymous]

@arhetyp,

Based on your screenshot, there are no relationships(direct relationship or indirect relationship) among the three slicer tables, thus when you select value in one slicer, the other two slicers will not be filtered.

Why not add the Country, Area and Town fields in a single table?


Regards,

[arhetyp]

Thank you.

I am aware there is no both direction links for all free slicers and that is the reason for lack of interacting between them.

However I am not able to link them this way - I have been trying for 2 days:)

I tought about one slicer table instead of 3 but how do you advice to build it? 

Should I just manualy enter list with all possible options for 3 slicers?

Actually I need 8 levels/slicers not 3.

I am going to filter 20 different fact tables so maybe while creatring slicer list should I base on data from let's say one master fact table which covers all posible options?

By option I mean that in Brasil there are 3 possible areas, for each area 2 different towns and so on.

Regards,

Arek

[Anonymous · Accepted solution]

@arhetyp,

If you don't want to add all slicer fields in a single table, you can consider to create relationship between Table 1 and Table 2. Make  the connection between Table 1 and Table 2 into both cross filter directions, and change those connections(Table 2 and the slicer tables) into both cross filter directions.

Besides, when creating a single slicer table, you would need to manually enter list with all possible options for slicers.

Regards,

[arhetyp]

I have created one slicer tables, and it actually works correctly:)

Thanks a lot.

However I need to connect one more fact table (FTE) which consist only of two slicer dimensions: Country and Area (there is no town level).

I have created the second slicers table to cover unique options for these two dimensions and linked slicer witth FTE Table by new Key (Country+Area) however previously created slicers do not filter correctly these data.

Does it mean that to filter data on slicers for all tables I need only one slicer?

To create unique key for fact table (so i can directly link two fact tables) I need to summarize some data wihthin one tables - do you think it is a good idea?

Regards,

Arek

[EddyJawed]

I'm experienciong the same problem. It seems that regardless of wether one slicer table is indirectly connected to another through a third ('n-between) dimension table, Power BIO is still not able to recognise a link. It seems you have to make the best use of one fact table to power all your slicers and visuals if you want them all to sync between each other. 

[EddyJawed]

I'm experienciong the same problem. It seems that regardless of wether one slicer table is indirectly connected to another through a third ('n-between) dimension table, Power BIO is still not able to recognise a link. It seems you have to make the best use of one fact table to power all your slicers and visuals if you want them all to sync between each other.