Forum Discussion
Filter table visual based on values in a column
This seems like it should be simple, but I have no idea how to do it. This report has a single table. One of the fields in the table is named Tests. All values in the field are 1. For the table visual shown below, the Tests column is simply a SUM of the values in that field. In other words, it's a count. How can I do something like what I have shown above the visual? I want the user to be able to limit what is shown by entering a Minimum for Tests. Thanks for any suggestions.
see if this helps
6 Replies
Your Tests slicer/parameter needs to be fed by a disconnected table, and then you use measures to get to the columns on the right.
Thank you for the reply. I should have said I am very new with Power BI. A couple of months at most. I understand when you say the parameter needs to be fed by a disconnected table. I think I can do that. I have no idea how to create a measure that would then limit what shows up in the table. Can you help get me started down that path?
yes. The easiest way for me to help you is if you provide sample data that covers your scenario. Ideally in a usable form (not as a screenshot)
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to 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
