Different year value in a single bar with different color

[Anonymous]

hello everyone,

i have below chart, which is contain monthly sale

but i want show like below,means in a single bar it will show only jan's 16 and 17 sales(no need to show year in chart) data with two different color how it will be possible?

Thank You.

[Anil_Babu_Samineni]

That's not possible. Are you expecting 2016 and 2017 same as in your Image?

[Anonymous]

I am expecting like below

[Anil_Babu_Samineni]

Looks like achievable.

Create Bar chart and

Dimension is

Month(FieldName)

Expression

Sum({<Year = {'2017'}>} Sales)

Sum({<Year = {'2016'}>} Sales)

And setting should change like in style tab you need to change from Group to Static.

[tresesco]

Try like:

Dim1: Month

Dim2: Year

Exp: <your exp>

Bar chart->Style tab->Subtype 'Stacked'

[jyothish8807]

Try this:

Use staked chart option.

Br,

KC

[devarasu07]

Hi,

may be this?

[Anonymous]

it show like this

[Anonymous]

i am not able to read QVW file, please share a screenshot

[Anil_Babu_Samineni]

Yes, You need to plot the inside the data points and disable the option called "Show the total on Top" in the presentation tab.