Bar chart | How to plot a point on a bar chart ?

[kaushi2020]

Hello everyone, 

Here in the image - length of bar shows sum of sales per year for a set of customers.

If I want to show a point on this BAR for a single client based on customer selection filter, is it possible ? 

Expectation:

When user select customer name from filter pane, the sales for each year should show as a point on these bars. refer example screenshots for reference. 

here the bar chart is static and it does not filter based on details selected in the filter pane. 

[justISO · Accepted solution]

Hi, it is possible to do this like this: you take 'Combo chart' with year as your dimension and measure for length of bars

Sum({1}sales)

Notice, that {1} are making expression to ignore all filters, so these bars will become static. No you create 'Height of line' with measure

if( GetSelectedCount(customer)=1, Sum(sales) )

On same expression you press 'More properties', choose Marker and set in Primary axis. Create filter and it is done. Only when you choose one customer, its result appear in chart:

[kaushi2020]

thanks for replying. I am using an enterprise edition cloud. I am not able to see more properties. 

[justISO]

What chart are you using? Probably still bar chart, not combo chart, as I suggested.

[kaushi2020]

apologies for not checking the chart type. I had to change it now from Bar to Combo and it worked. It made my Day 🙂 thank you so much.😌

[kaushi2020]

Hello, Just curious , is there any way we can plot similar dots on a BOX Plot ?