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.

[Anonymous]

i already done this.

[Anonymous]

please share a screenshot, i am not able to read qvw

[Anil_Babu_Samineni]

Have you enable the "Data points" for each expression?

[Anonymous]

yes

[devarasu07]

Hi,

Refer,

Fact:
load *, Year(Date) as Year,Month(Date) as Month,Date(Date,'MMM-YY') as MonthYear;
LOAD * INLINE [
    Date, Sales
    31/1/2016, 40
    31/1/2017, 50
    20/2/2016, 45
    28/2/2017, 70
];

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

try to create bar chart as like below way

1st dimension in your bar chart: Month &

add Year as 2nd dimension

expression;

sum(Sales)

after that enable data points for this expression tab

right clik your chart object and go to chart properties -->style--> subtype as Stacked

and then go to presentation enable check box as "Plot values inside segments"

[Anil_Babu_Samineni]

Can you attach QVW which demonstrates the O/P

[Anonymous]

please find attach file

[Anonymous]

but i need to show two different year and their same month in single bar

[Anil_Babu_Samineni]

Your values not showing because Height issue. You need to rid that using increase the height or showing in % values

[Anonymous]

it shows for only 2016 and 2017 but i have many years