Visualizing Multiple True / False with changing List of devices

[RRanks]

Hi,

I have a table with a list of device types, and some True/False Status values I need to put into a vizual.. I was thinking multiple Donut Charts might be good but not sure how I can do that with a changing list of device types.

Would be good to show in the visual:

• Total of Device Type
• % isSync True/False
• % isAutoSync True/False
• Would also like it ordered so devices with largest number are at the top
• Would also be good if a new type is added that it appears in the visual without having to manually go back and add an extra donut chart etc..

Table would look like this:

DeviceType,isInSync,isAutoSycn

DeviceTypeA,True,False

DeviceTypeA,True,True

DeviceTypeA,False,True

DeviceTypeA,False,False

DeviceTypeB,True,True

DeviceTypeB,True,True

DeviceTypeB,True,False

DeviceTypeC,True,True

DeviceTypeC,False,True

DeviceTypeC,False,False

DeviceTypeC,True,True

DeviceTypeC,True,True

DeviceTypeD,True,False

DeviceTypeD,True,True

DeviceTypeD,False,True

DeviceTypeD,False,False

DeviceTypeD,True,True

Thanks!!

[lbendlin · Accepted solution]

Use two bar charts.  They will be automatically sorted by the count of items. They will adjust when new device types come in.

[v-xianjtan-msft · Accepted solution]

Hi @RRanks 

Here is my solution, hope it helps.

1. Create a measure to calculate total of device types.

TotalDeviceTypes = CALCULATE(DISTINCTCOUNT('Table'[DeviceType]), ALL('Table'))

 2. Create two Donut charts and put “DeviceType” in “Legend” and “isInSync/isAutoSync” in “Values” and select as count, put the new measure[TotalDeviceTypes] into ‘Tooltips’.

 3. In the visual format settings, expand “Detail labels” and select “All detail labels” in the “Label contents” drop-down list.

4. Select the Dount chart, and set the sort to be “DeviceType” descending.

5. Here is final result.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Use two bar charts.  They will be automatically sorted by the count of items. They will adjust when new device types come in.