Forum Discussion

zhanghonwork's avatar
zhanghonwork
New Member
1 year ago
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...
Need Help
  • audreygerred's avatar
    audreygerred
    1 year ago

    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.

v-priyankata's avatar
v-priyankata
Community Support
11 months ago

Hi zhanghonwork 

Thank you for reaching out to the Microsoft Fabric Forum Community.


Ashish_Mathur audreygerred Thanks for the inputs.

I hope the information provided by users was helpful. please try those, If you still have questions, please don't hesitate to reach out to the community.

 

v-priyankata's avatar
v-priyankata
Community Support
11 months ago

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.

  • v-priyankata's avatar
    v-priyankata
    Community Support
    11 months ago

    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.