Forum Discussion
Visualizing Multiple True / False with changing List of devices
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!!
Use two bar charts. They will be automatically sorted by the count of items. They will adjust when new device types come in.
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.
2 Replies
- lbendlin
Super User
Use two bar charts. They will be automatically sorted by the count of items. They will adjust when new device types come in.
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.