Forum Discussion
Data Comparison Visualisation
Hi,
I am trying to find a way to replicate (or atleast produce something similar to) the interactive tool found here: Subnational indicators explorer - Office for National Statistics (ons.gov.uk)
The data for the tool is available to download underneath it.
I am new to BI and have tried my best to find a visualisation that works, but the closest I have found at the moment is just a scatter chart using the Indicator as the X-axis, the median deviation (MAD) as the Y-axis and the Area name in the legend.
Unfortunately, there are too many area names for the scatter chart so not all of them are shown.
So I am wondering:
1. If there is a better visualisation to use, which might hopefully be able to handle all of the area names.
2. Is it possible to make it so that when one or more areas are selected in a slicer, that they are highlighted in the visual, with the other areas becoming transparent.
Thank you in advance for any help, it is much appreicated.
- Anonymous4 years ago
Hi Anonymous,
You can take a look at the power bi app store and try to find out some of the custom visuals if they suitable for your requirement.
Business Apps – Microsoft AppSource
In addition you can also try to use script-based visuals(python, R) to manually plot these graphs if you familiar with code scripts.
Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi Anonymous,
You can take a look at the power bi app store and try to find out some of the custom visuals if they suitable for your requirement.
Business Apps – Microsoft AppSource
In addition you can also try to use script-based visuals(python, R) to manually plot these graphs if you familiar with code scripts.
Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng