Selecting based on filters

+1 vote


For below data

OrderID Value Above 100
1 110 Yes
2 90 No
3 150 Yes

1. How can select create a measure selecting only "Yes"


2. I need data where Above 100 is "Yes"

Aug 11 in Power BI by anonymous
• 210 points

1 answer to this question.

+1 vote


If you have more than one table or visual on the same page, then do not use a slicer for filtering, else use a slicer.

1. Create a table with OrderId and Value fields. 

2.  If more than one visual or table is on the page, then Next drop the Above 100 field in visual level filters shelf as shown below and go to basic filtering then select yes, 

else create a slicer from visualizations pane with Above 100 field.

Hope it helps!

answered Aug 11 by anonymous
• 19,550 points
Thanks for the response.

Forgot to mention that I have relationship built with another table and when I select this slicer as you mentioned it will affect the 2nd table as well.
Sure. So add the Above field in the visual filter so as to not affect other table or visuals.
So does the solution help your question or any change to your question?
I am using 2 values in one table.

So when I apply above 100 slicer on the visual level filter the other value of also getting impacted.
Add Above a field in visual level filters only and not in the slicer.

If you add Above 100 field in slicer as well as visual level filters then the slicer will affect your table and also the visual filter.

If you have added so then remove the slicer and keep only visual level filter.

Related Questions In Power BI

0 votes
1 answer

Locating closest match based on Latitude & Longitude

First of all, we need to use the ...READ MORE

answered Jan 2 in Power BI by Shubham
• 13,290 points
0 votes
1 answer
0 votes
1 answer

Applying multiple filters in PBI Embed URL

Well, that is actually a limitation in ...READ MORE

answered Aug 21, 2018 in Power BI by DataKing99
• 8,100 points
0 votes
1 answer

Group by columns on Power BI

On power BI desktop, do the following Add ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 39,170 points
0 votes
1 answer

Display power bi report on my desktop application

Power BI has a new feature called ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 39,170 points
0 votes
2 answers

Send dashboards and reports as automated emails on power bi

check this: ...READ MORE

answered Mar 21 in Power BI by Bob Jenkins

reshown Mar 22 by Vardhan 1,809 views
0 votes
1 answer

Power BI Report Viewing on Local Repository?

Use REST API to embed the reports in ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 39,170 points
0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 14,090 points
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 19,550 points
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26 in Power BI by Cherukuri
• 19,550 points