Forum Discussion
Report level filter, Require single selection
I am wondering if there is a way to require a single selection on a Report Level Filter? I see the check box when I have it as a page level filter, but do not see the check box when I drag the field to the Report Level filter.
6 Replies
nchinbong if you want single select then you will have to use page level filter as with visual and report level filters you don't get single selection and i think this is by design.
Hi nchinbong,
Based on my test, single selection is also available in Report level filters. In your scenario, when you drag a field to Report level filters, please check if it's Basic filtering or Advanced filtering. The check box is available in Basic filtering instead of Advanced filtering. See:
Basic filteringAdvanced filtering
Reference:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun YuHi v-qiuyu-msft,
Below, highlighted in yellow is the option I was looking for. It appears in the page level filters, but not in the report level filters.
If this is by design, do you know why (ankitpatira)?
Hi nchinbong,
I have also found the "Require single selection" is not available in Report level filters. In my opinion, the report may contain many pages and lots of visuals, and the report level filters are applied to whole report. If we check only one value in report level filters, it's possible that not all visuals can display data well. Also without "Require single selection" enabled, we can also check one value each time. So the "Require single selection" is not required.
In your scenario, if you really want the "Require single selection" feature in report level filters property, you can post your idea in Power BI Ideas forum at this link: https://ideas.powerbi.com/forums/265200-power-bi-ideas .
Thanks for your understanding and support. :smileyhappy:
Best Regards,
Qiuyun Yu
Any update on this please???
