Selecting based on filters

+1 vote

Hi,

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"

OR

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

Aug 11, 2019 in Power BI by anonymous
• 230 points
83 views

1 answer to this question.

+1 vote

Hi, 

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, 2019 by anonymous
• 32,460 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, 2019 in Power BI by Shubham
• 13,380 points
770 views
0 votes
1 answer
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 17, 2019 in Power BI by anonymous
• 3,380 points
255 views
0 votes
1 answer

last 10 days data based on Date&time

Hi, @Vnk, Regarding your query, you have to ...READ MORE

answered Jun 4 in Power BI by Gitika
• 31,430 points
128 views
0 votes
1 answer

Dynamic title Based on Date

Hi, @Vnk, You can try this: [Date(WindowMax)(Title)] = WINDOW_MAX( ...READ MORE

answered Jun 15 in Power BI by Gitika
• 31,430 points
29 views
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,150 points
1,498 views
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
• 51,890 points
123 views
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
• 51,890 points
91 views
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, 2019 in Power BI by Cherukuri
• 32,460 points
4,802 views
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, 2019 in Power BI by Cherukuri
• 32,460 points
1,268 views