When using a bar graph's bars as a selectable filter: How to highlight the selected bar.

#1

Hi guys,


I'm using [stacked] bars on a [stacked] bar graph as a selectable filter for the other visualisations on a layer of a dashboard.

What I need to know is how do I also make that selected bar highlighted? Or to put it better; how do I lower the opacity of the non-selected bars whilst retaining the 100% opacity of the selected bar?


I've had a previous (yet still unresolved) similar issue about changing the background colour of a treemap also being used as a selectable filter.

https://dundas.influitive.com/discussions/topics/55976?page=1

Would attempting a similar approach to those two suggested in that answer be the best options?

#2

In the case of bar charts this is much easier.


First, select the chart and open the Look properties. Uncheck the property Hover To Select Points and instead select Click To Select Points. This is just to make sure the bar remains selected after you click.


Select the series (either by clicking on a bar chart or by clicking the Data Point Series in the Main properties). In the Look properties for the series, expend Select Data Styles and click Unselected Point Style. Image title


set the Opacity Offset to a negative value. In the following example it's -50%:

Image title

#3

Hi Elia thanks for your response.

That was actually the first thing I'd tried. What I should've specified above it that the bar chart is actually a stacked bar chart. So unfortunately when I attempt that; it merely slelcted the stacked "column" clicked-on, and not the entire bar.


Is there a way around that?


Another thing I should've added is that the colour of the sections of the bars are defined by those columns, and not set as data points.

#4

Hi I still haven't resolved this.


Would it be possible to iplemnt this by using more than one metric set on the visualization?

#5

To select all of the points making up a stacked bar, you could write a script that selects data points.


Another way is to use filter interactions to pass a clicked value to a formula measure with a $parameter$ placeholder to trigger either states or colour rules to make data selected. If there is a numeric ID column, this does not require script of any kind, otherwise a more complex formula that includes an if-statement that compares unique names against a string-type parameter can return a particular numeric value when there is a match.