Forum Discussion
How to Filter a Visualization to Display Only Data Similar to a Selection (Disconnected Tables)
By stores with "similar" sales, I mean stores with sales that are plus or minus X% from the sales of the store selected. This selection problem was solved by Mr. Mathur, referenced above, by using a disconnected table of percentages and then using that disconnected table to create measures that are used as filters in a calculate function. So, a user could click on a store, then select a range (+/-X%) to apply to the sales, and find the stores whose sales are within that range -- Mr. Mathur did so with a concatenated list; I was looking for a bar chart.
Basically, my problem here is that Power BI does not allow measures to dynamically filter slicers. For example, if I have measures defining a range of values (+5% and -5% of a selected store's sales), I cannot feed these into slicers to automatically filter the rest of the page. My best solution was to have cards displaying the range values generated above the slicer, so the user could define a range and then plug the resulting values into the slicers themselves.
- lbendlin3 years ago
Super User
Basically, my problem here is that Power BI does not allow measures to dynamically filter slicers.That is mostly true, but not always. You can use measures as visual level filters in certain circumstances.
However your scenario seems to be better served by educating your users on how to use the basic Power BI filtering functionality, by promoting the use of the filter pane, and by enabling the "Personalize visuals" option.