Forum Discussion

MarksmanWaugh79's avatar
MarksmanWaugh79
Frequent Visitor
3 years ago
Solved

Visualising Devices per App, Apps per Device via Histogram or Scatter

Hi,   I have a strange problem I haven't faced before.    We have two lists, a list of devices and the related information (hardware vendor, OS, machine name, etc) and another list list of device...
General Comment
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

MarksmanWaugh79 can you share sample pbix file, remove sensitive information before sharing. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi parry2k,

Here's a small sample of device list, and app list.

 

As originally posted, I've been unable to get a visual to work like the screenshot in the OP, that shows number of devices on one axis, number of apps on the other axis, and relate them such that it highlights where devices have many apps (or few apps). We're certain we could get histogram to show this or scatter with some DAX magic.

visualising-devices-per-app-and-apps-per-device.pbix (Google Drive)

Thanking you kindly. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Based on the PBI file that you hae shared, show the expected result very clarly in a simple Table format.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Ashish_Mathur, 

       

      That was suggested. Customer adamant they would like a histogram or scatter to visually plot - were not happy with the table visual when shown. 

       

      Given this is what a histogram was designed for. 

       

      Still hoping to find a visual solution to show the grouping/bins. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Once we get the correct numbers in the Table, we can always build a scatter plot.  I just want you to show me the correct figures in a Table format.