HI,
in PBI Desktop I visual level filters i can set. but this filter is not visable in Power BI ( after publishing).
Means i have to set the filter , but I want that the people deside by themself if they want to see the full data or only a part.
in my excample i want create a filter for people to use like "show items if values is greater than 100"
but as it is a measure, i can not use a slicer or put it on report filter.
is this possible at all?
Solved! Go to Solution.
I did not click on visualisation . now i can see 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/
Proud to be a Super User!
I did not click on visualisation . now i can see Thanks very much
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
374 | |
101 | |
68 | |
57 | |
51 |
User | Count |
---|---|
335 | |
123 | |
88 | |
71 | |
64 |