Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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.

 

1 Reply