Forum Discussion
dynamic filter value - not equal to
I have a table with SCCM data containing AddRemoveProgram data. I can easily slice it up to find which computers have what SoftwareName installed.
It has been requested to slice/filter the data for finding computers that DO NOT have the selected SoftwareName installed. So when sliced by SoftwareName, I get table view with computers without the selected title. I might be approaching this wrong but I cant seem to get started.
device | SoftwareName
computer1 | application1
computer1 | application2
computer1 | application3
computer2 | application 2
computer2 | application4
computer3 | application 1
computer3 | application2
computer3 | application4
I can slice by SoftwareName, select "application2", and get table view with "computer1, computer2, computer3" or select "application4" and get "computer2, computer3"
I've been asked to label a slicer Not Installed and when selecting "application4" I see only "computer1" in the table view as NOT having SoftwareName "application4"
Is this possible?
Thank you,
kevin
3 Replies
it's going to permute your columns, but you can make calculated columns that are the inverse of each title, and then filter on those? I realize it's not ideal, but would solve it.
also perhaps building a set of software programs as a separate table, and then build measures against that, something like this:
https://community.powerbi.com/t5/Desktop/Slicer-reverse-selection-in-chart/td-p/96316