Skip to main content
Question

Power Bi Desktop - Application rapport

  • May 20, 2022
  • 6 replies
  • 44 views
C
Forum|alt.badge.img+8

I want to create some very simple rapport with powerbi Desktop application. I found Jamf video´s on this

https://marketplace.jamf.com/details/power-bi/

They cover mainly computer, and I look to make a dashboard for software applications. Like A pie chart with how many devices are are latest OS version etc.

I have really not knowledge on Powerbi, so wonder if anyone can explain me what I should select. If I select the applications name and version like below, I got all applications and version. But how to I create a rapport only for specific applications like OS, Chrome etc

 

    6 replies

    C
    Forum|alt.badge.img+8

    S
    Forum|alt.badge.img+4
    • StefanT
    • Contributor
    • May 20, 2022

    First you need a list of all applications and their Versions as well as a count of Computers as  (eg using their name, serial or Jamf ID ), then you put a filter on your list to only display the applications you want. This filtered list can be turned into a Chart.

    For OS it's different since it's not an application. The OS is stored in the field computerdetails.os_version. Grab this field and a count of computers (again using name, serial or jamf id).

    C
    Forum|alt.badge.img+8

    I don´t know what I miss - but I guess I am quite close. 

    So I have selected all photoshop versions and my goal is actually to show how many clients run Photoshop 2022 22.4.3 and 22.5.0 etc.

    So actually in the one screenshot I actually have the information, but  when selecting "count" it just shows overall how many Photoshop 2022 I have - where I want to have each version information so I can see that like 5 clients are running 22.5.0, 10 clients 22.4.0 etc

     

     

    S
    Forum|alt.badge.img+4
    • StefanT
    • Contributor
    • May 23, 2022

    I don´t know what I miss - but I guess I am quite close. 

    So I have selected all photoshop versions and my goal is actually to show how many clients run Photoshop 2022 22.4.3 and 22.5.0 etc.

    So actually in the one screenshot I actually have the information, but  when selecting "count" it just shows overall how many Photoshop 2022 I have - where I want to have each version information so I can see that like 5 clients are running 22.5.0, 10 clients 22.4.0 etc

     

     


    The count shouldn't be on the Version, but on Computers, so you'll need the add the Computer name or ID and set this to count. So drag in the ID from the Table Computers (might also work with the ID from the Computer - Applications Table). 

    If Power BI can't make a connection between the data from the Computer Table and the Applications Table, then you need to setup a relation between these first. 

    C
    Forum|alt.badge.img+8

    Yes I figured it out. The last thing I don´t know how to change is the order of the versions. How can I change it so they don´t jump arround in different versions

     

    S
    Forum|alt.badge.img+4
    • StefanT
    • Contributor
    • May 26, 2022

    Yes I figured it out. The last thing I don´t know how to change is the order of the versions. How can I change it so they don´t jump arround in different versions

     


    I'm afraid i cant help you with that. Thats an issue i am battling with myself.

    Terms & ConditionsCookie settingsAccessibility statement