Forum Discussion
Solved
Parameters slicer
I have 6 sales related tables which have the same column called company, it is 3 digit code like 100 is subsidary 1, 200 is subsidery 2. I want to create a parameter slicer in page to acheive th...
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
not enough information to be useful. Please give a general reply that can be adapted. how would this work if the parameter is a date, not a code?
Basically, I want to make the dynamic parameter in power query to control the company to be available in power bi report. The folllowing link gives me a glispe of hope. I will test it to see if it works.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters