Forum Discussion
Filters with Multiple Conditions
Anonymous Super vague. Maybe a Complex Selector? The Complex Selector - Microsoft Power BI Community
Otherwise...Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi! Yes...
Source data
| Column 1 | Request Type | Client | Column 2 |
| abc | Defect | California | fdg |
| def | STI | Texas | vdgbaZ |
| abfe | RM | Missouri | dzvdvf |
| dfer | Enhancement | Iowa | bfsb |
| Defect | Texas | ||
| Defect | Missouri |
My selection on the left should give me options for the days of the week... Monday, Tuesday, Wednesday, Thursday and Friday
Output:
When user selects Monday, the report should filter by 'Request Type = Defect, STI, RM' AND 'Client = 'Missouri, Texas'.
| Column 1 | Request Type | Client | Column 2 |
| Defect | Missouri | ||
| Defect | Texas | ||
| RM | Missouri | ||
| STI | Texas | ||
| RM | Missouri |
I will have specific values for Request Type and Client for each day of the week.
Hope this helps, please let me know if more info is needed. Thank you!
and so on
Anonymous Yeah, you are in Complex Selector territory. See that recipe in the Quick Measures Gallery.
I'm getting this error when trying to use the expression on the complex selector page.
Am I using right expression, please advice.
Anonymous Need a comma between your table name and your column name that you are grouping by.