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
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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Ashish_Mathur 

       

      That's one of the problems, only have DAX or Power Query as there is no ability to write queries at the source here. So somehow need to perform the counts via some sort of DAX Summary table, or something. 

       

      So list of devices and the count of apps for each device. Then List of apps and count of devices for each app. Then somehow relate them and plot.