Forum Discussion
How do I flag Compliant vs. Noncompliant Software Versions?
Hi all,
I am new to Power BI and I am racking my brain trying to figure this out.
I am responsible for reporting software versions compliance (meaning that it is up to date/patched/current/etc...).
I am pulling a managed device and application data with PowerShell Graph for Endpoint Reporting, basically I can see what application versions are installed on which systems. (see pics)
My problem is that only two versions are up to date and the rest are not. I would like to be able to create a checkbox for each version that will let me confirm if a version is compliant or not.
It doesn't have to be a check box, but some way to quickly flag a version True/False or Yes/No, Good/Bad, etc...
The goal would be to have a new chart that shows all the versions of an application installed on our managed computers. Then be able to select which versions are compliant (like a slicer maybe?), and have the chart show what percentage of the installed applications are up to date.
I really want avoid having to go into Transform Data and create duplicate columns and then put the complaint versions in one and the noncompliant in another, and then repeat all that work every time one of 20 different applications gets updated across 800+ computers in the report.
I may be asking the for the wrong thing in the question or drastically overcomplicating something. I have tried seaching forums, articles, tutorials, Youtube, etc... and I can't find anything like what I am looking for. I can't even find someone asking the same questions which tells me I may be looking at this wrong in the first place. I'm really feeling the "I don't know what I don't know right now".
Any help would be much appreciated.
Thanks,
-Jonathan
9 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.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.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- Jolo_SGRegular Visitor
Hey lbendlin,
Thanks, I will need to get permisson from Security before I can do that. They may have me edit some sensitive information, but I don't think that will cause problems with the sample data.
- andhiii079845
Solution Sage
You can perhaps use "New Group" to but the different Version in groups. Right klick the version column: NEW Group, choose list.
- Jolo_SGRegular Visitor
deviceName displayName id.1 version QTSQATERMINAL3 Mozilla Firefox (x64 en-US) 0000d26324c7fd7e8c7705daded5ecc9931a0000ffff 103 2T8FTG3-HQL Mozilla Firefox (x64 en-US) 00009a377e65ef971c6a7883cb88be0f7ae20000ffff 106.0.1 6CMGMQ2-HQL Mozilla Firefox (x64 en-US) 00002e8725f72ffacf784e7b9898e32335660000ffff 107.0.1 HNKX9K3-HQL Mozilla Firefox (x64 en-US) 00002e8725f72ffacf784e7b9898e32335660000ffff 107.0.1 PF3ZH1LJ-HQL Mozilla Firefox (x64 en-US) 00002e8725f72ffacf784e7b9898e32335660000ffff 107.0.1 1QCFTG3-HQL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 24XSTN2-HQL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 3ZWRQ73-HQL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 5PDLXT2-HQL5 Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 B19FTG3-HQL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 C8D2ZW2-HQL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 CQDFN73-HQL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 H0PK5S2-CAL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 J06Y0J3-CAL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 JMHKWT2-CAL Mozilla Firefox (x64 en-US) 000055a4971adb6359e6919f5b8d0fcc23250000ffff 108 2HP1Q73-RML Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 5SQP5S2-HQL Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 6BPDX33-HQL Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 6ZPGN13-HQL Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 C61FX33-RML Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 FCFRYW2-HQL Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 R90VFVTK-HQL Mozilla Firefox (x64 en-US) 0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff 108.0.1 2NWSWT2-HQL Mozilla Firefox (x64 en-US) 0000259ee4f7aa982814b4cddc4c0df250690000ffff 108.0.2 D3D2ZW2-HQL Mozilla Firefox (x64 en-US) 0000259ee4f7aa982814b4cddc4c0df250690000ffff 108.0.2 DQX6VN2-HQL Mozilla Firefox (x64 en-US) 0000259ee4f7aa982814b4cddc4c0df250690000ffff 108.0.2 F3LJ3F3-HQL Mozilla Firefox (x64 en-US) 00007f403aab0b5c26affbdbe474f5ea4c240000ffff 109 G7VF3F3-RML Mozilla Firefox (x64 en-US) 00007f403aab0b5c26affbdbe474f5ea4c240000ffff 109 4G4H793-HQL Mozilla Firefox (x64 en-US) 00006e1df073188511062abb53d365122aa00000ffff 109.0.1 3YDFN73-HQL Mozilla Firefox (x64 en-US) 0000917e3587c4107a96e9c0b0803231bdcd0000ffff 110 54JTQC2-HQL Mozilla Firefox (x64 en-US) 0000917e3587c4107a96e9c0b0803231bdcd0000ffff 110 F6FN793-RML Mozilla Firefox (x64 en-US) 0000917e3587c4107a96e9c0b0803231bdcd0000ffff 110 G36ZTT3-HQL Mozilla Firefox (x64 en-US) 0000917e3587c4107a96e9c0b0803231bdcd0000ffff 110 CG7NQ13-HQL Mozilla Firefox (x64 en-US) 0000ec6a6ec3e37cb4457dabc7474dc98f340000ffff 110.0.1 1SCFTG3-HQL Mozilla Firefox (x64 en-US) 00000b2f6d20489ce0d82fceac74635595750000ffff 111 209FTG3-HQL Mozilla Firefox (x64 en-US) 00000b2f6d20489ce0d82fceac74635595750000ffff 111 42BKWT2-HQL Mozilla Firefox (x64 en-US) 00000b2f6d20489ce0d82fceac74635595750000ffff 111 94FWQN2-HQL Mozilla Firefox (x64 en-US) 00000b2f6d20489ce0d82fceac74635595750000ffff 111 FRCFTG3-HQL Mozilla Firefox (x64 en-US) 00000b2f6d20489ce0d82fceac74635595750000ffff 111 BK989K3-HQL Mozilla Firefox (x64 en-US) 00006aae3660b021e2079de9cf670e254df00000ffff 111.0.1 D1D2ZW2-HQL Mozilla Firefox (x64 en-US) 00006aae3660b021e2079de9cf670e254df00000ffff 111.0.1 10JDX33-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 119FTG3-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 169H0J3-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 174T3J3-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 182GFG3-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 182YW33-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 18GCM33-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 191FX33-HQL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 1H7RF13-CAL Mozilla Firefox (x64 en-US) 0000f1f63cd9d49ba4820083fd4018c49dc20000ffff 91.0.2 - andhiii079845
Solution Sage
I would prefer that you create only a table with the current compliant Version of the different software.
You can than create a easier mapping what is compliant and not. You can also buid this table in excel and import it in the report.
- Jolo_SGRegular Visitor
This is an sample.
There are multiple versions of Firefox installed.
This is pulled from 800+ systems every day and compiled in Power BI to show Application Version Changes over time.
I'd like to be able to find a way to flag certain version numbers as Compliant or Non-Compliant without having to manually enter that information into a cell for every version, on every system, for every date.
This is what my report looks like right now.The compliance score I have is a text box that is manually calculated everytime I update the report.
I'd like to be able to use the Version box (Slicer) on the bottom right to click which versions out of all of them are good and then have it calculate a compliance score automatically. (I am aware that using a slicer is probably the wrong way to do this, but I can't really think of another interface that will let me make selections)
-Thanks 🙂
- andhiii079845
Solution Sage
You can make a dimensional table only for the current complaint version of the different software. and every other version is non complaint. Can you perhaps show only some data from the involved tables please with the column names?
- Jolo_SGRegular Visitor
Every Time I try and copy and past Table data it dissappears.