Forum Discussion
Solved
How to Retrieve data dynamically based on user selection
Hi I have a request to build a report. There is a slicer that has two values in dropdown: include and exclude. When user choose the "include", the report will display all data. When user choose "excl...
In Power BI, not selecting anything from the filter is the equivalent of showing everything (i.e. you are not filtering). If you want it so that when a selection is made only 1, 2, 4, 5 show up - the user would select INCLUDE. If they select EXCLUDE it would show 3. No filter show 1, 2, 3, 4, 5. You can change the verbiage and have include be exclude and vise versa, but to show all items - you filter nothing.
Hi zhanghonwork
I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.
Hi zhanghonwork
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.