cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sonne Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Sonne Frequent Visitor
Frequent Visitor

Re: Measure as a filter

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

2 REPLIES 2
Highlighted
kcantor Super Contributor
Super Contributor

Re: Measure as a filter

@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 Datanaut!




Sonne Frequent Visitor
Frequent Visitor

Re: Measure as a filter

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 102 members 1,658 guests