Forum Discussion
Measure as a filter
I did not click on visualisation . now i can see :smileyembarrassed: Thanks very much
Yes, it is possible. Your filter is actually still there. You need to click on the visual for the visual level filters to appear. Generally, I I use one of these filters, I will provide training and documentation to my users and have occasionally posted a hover over reminder as a tool tip to remind them of how to access that particular filter.
Also note, there are other methods of accomplishing this such as a switch measure with a slicer to determine the baseline filter. Those can be used with most types of data and work really well. See this blog for more information on that. https://stackoverflow.com/questions/50929240/how-to-capture-slicer-value-by-dax-measure
Another good resource: https://powerpivotpro.com/2013/08/moving-averages-controlled-by-slicer/
I did not click on visualisation . now i can see :smileyembarrassed: Thanks very much