Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 🙂
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?
Proud to be a Super User!
Every Time I try and copy and past Table data it dissappears.
Maybe your company's security policies are interfering.
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 |
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.
Proud to be a Super User!
You can perhaps use "New Group" to but the different Version in groups. Right klick the version column: NEW Group, choose list.
Proud to be a 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-...
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
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |