Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
I have 45,000 computers and 34,000 software titles. I looked at the link you suggested and I dont think that solution is pratical in my situation. My table already has 6.3 million rows.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |