Forum Discussion
How do I flag Compliant vs. Noncompliant Software Versions?
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?