Forum Discussion
Dynamic Parameters ( Multiple parameters that talk to themselves ) EG: Plant-Line-Material
Community Championcould you not just pass a plant name via a filter in power bi and use cte's in a view in sql to do the rest? you need to give more information, this is sort of conceptual but without understanding the structure of your model its hard to advise on the situation
Thanks, Vanessa for your response. I will try to be more specific and will share some screenshots.
Thought to redo the first picture:
- vanessafvg
so what does your data model look like in dq? ie. are you pulling from two separate dimensions? maybe there is a dax measure you can use a flag with isfiltered placed on the filter pane to get the correct scope and have some calculation logic in there that triggers the fact that understand the relationship inbetween to reduce what you bringing back in the slicer.
sometimes a use case calls for unconvential methods, maybe you could create a table with distinct values of that plant / station combination using a snow flake? Or maybe its even worth denormalising the tables if the performance and user experience is that unpleasant?
been a long week so my brain might not be working.
there are also ways of optimising your back end depend on what db you are using.
Sorry for the delayed response. I use only 1 Data source.
The other lists are just the Slicers that have parameters bound to them and the parameters are injected in the original SQL.