Forum Discussion
Parameters slicer
gavin007 , do you common company code table joining to all these tables.
If not have one like
Company Code = distinct(union(all(Table1[code]),all(TableB[code]),all(TableC[code]),all(TableD[code]),all(Tablee[code])))
and join it all 6 tables and use code from this table slicer
amitchandak the 6 tables are mix of master tables like customer, item and transactional table like actual sales and budget sales.
they are linked together but not through company code. e.g. customer master table link to sales tables through customer code. There is no such table called company code to link them together.
I guess my question is how to filter those 6 tables when user select the company code in the slicer. At the moment, i can do it only in parameter in power query.
amitchandak i have fixed the problem by using normal slicer base on company column. Your idea is not the same as what i have implemented, but I take the idea of building a related table set.
I was confused with the parameter and slicer in a connected tables. My original idea is to have paremeter filter in power query so that when user select it, it will filter the data. The only problem with is is end user are not supposed to change what view they are allowed to see based on dynamic dataset, they should be restrained by RLS based on the same data set.