cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Advanced Filters and Filtering

I have been successful in creating individual tables with the below criteria, but It has been requested by my boss to combine and only show the results when the criteria have been met.  Any suggestions?  

 

 

 

 

Any Time     
 Show Unit ID, MAT, and status when MAT below 48F
When OA is 83 and above    
 Show Unit ID, MAT, and status when MAT above 78F
When OA is above 70F and below 83  
 Show Unit ID, MAT, and status when MAT above 75F
When OA 50F or below   
 Show Unit ID, MAT, and status when MAT above 70F
When OA above 50F and below 70F  
 Show Unit ID, MAT, and status when MAT above 72F
1 ACCEPTED SOLUTION

Accepted Solutions
mnayar Solution Specialist
Solution Specialist

Re: Advanced Filters and Filtering

@Anonymous i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.

 

you can write a swithc with following criteria

 

SWITCH(TRUE().

OA >= 83 && MAT < 48,"Y",

OA >= 70 && OA < 83 && MAT > 78,"Y",

"N")

 

Feel free to add the required conditions to create the filter and then filter results based on it.

View solution in original post

3 REPLIES 3
mnayar Solution Specialist
Solution Specialist

Re: Advanced Filters and Filtering

@Anonymous i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.

 

you can write a swithc with following criteria

 

SWITCH(TRUE().

OA >= 83 && MAT < 48,"Y",

OA >= 70 && OA < 83 && MAT > 78,"Y",

"N")

 

Feel free to add the required conditions to create the filter and then filter results based on it.

View solution in original post

Community Support
Community Support

Re: Advanced Filters and Filtering

Hi @Anonymous,

 

Could you please share you sample data here so that I can help with it?

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Re: Advanced Filters and Filtering

Ideally, I don't want to use bookmarks. 

 

PowerBi.PNGPowerBi1.PNG

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors