Forum Discussion
Power BI - multiple filtering
- Anonymous1 year ago
Hi melikekurrt ,
Please try this way:
Here is my sample data:Use Numeric range parameter to create another table for slicer:
The minimum and maximum values here correspond to the minimum and maximum values of fxPeriod in your original data, respectively.
Then use this DAX to create a measure:
Filter = VAR _fxPeriod = SELECTEDVALUE(fxPeriod[Parameter]) RETURN IF( ISFILTERED(fxPeriod[Parameter]), IF( MAX('Table'[fxClosedPeriod]) = _fxPeriod || MAX('Table'[fxOpenPeriod]) = _fxPeriod, 1, 0 ), 1 )Set up the filter as shown below:
Output:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Does your data model have a Calendar table? Are your slicers fed by disconnected tables or from the data model?
Lutfen, provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523