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.
1 ACCEPTED SOLUTION
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-...
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/1447...
It would be fantastic if you could help. If I get this piece figured out, it will be a huge help on a much larger project. Thank you so much.
The link below is to a copy of the file. I have created the disconnected table with a slicer. I want the user to be able to select a value from the slicer that would filter the table visual. Please let me know if you have other questions.
This is EXACTLY what I need. Thank you so much for taking the time to help. This will go a really long way to helping me understand what to do in these situations.
