Matjaz Kragelj on 02 Sep 2022 09:57:44
In the real world, we are used to not being bombarded with information right away, to being able to decide what we want to see. When using Power BI, we have a problem that we don't know how to solve.
We have 3 slicers. We would like to trigger a search when all three are met. Now we are seeing the result that the visualisations are being displayed over the complete set (even though nothing is selected in the slicers). However, by default (if we display the matrix) BI has already loaded all the data.
Imagine an example:
500 libraries, 10 years, 40 different indicators. But we would like to select 2-3 libraries two, three different years and only a few indicators.
Is it really not possible to reverse the process? Using "submit" to start the execution and display the query?
Matjaž