cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sonne
Helper II
Helper II

Measure as a filter

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.

 

filter.pngin 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?

1 ACCEPTED SOLUTION

I did not click on visualisation . now i can see Smiley Embarassed Thanks very much

View solution in original post

2 REPLIES 2
kcantor
Community Champion
Community Champion

@Sonne 

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/

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I did not click on visualisation . now i can see Smiley Embarassed Thanks very much

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!