Forum Discussion
Visualising Devices per App, Apps per Device via Histogram or Scatter
Anonymous sorry about that, I thought I already gave you the solution. Here it is. Cheers!!
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.
Super UserHi,
Based on the PBI file that you hae shared, show the expected result very clarly in a simple Table format.
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
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.
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.