Two Dimensions and One Measure, bar Chart with labels of dimensions displayed on X Axis.

[ntksharma]

Hi,

I am creating a bar graph with  two dimensions and wanted both the dimensions displayed on X axis as below.

I have used the expression Year(Date)&','&WeekDay(Date), and got the Year and day displayed for each bar. I wanted to show it in the above view.

Could anyone help me with it

[Lisa_P]

If you have Dimension1 as Year and Dimension2 as Weekday, if you turn off the legend under Appearance, Colors and legend it will appear like this:

[ntksharma]

Hi Lisa,

Thanks for the update, but my two dimensions are different,

1. Date - where i wrote the expression Year(Date)&','&Weekday(Date), this is taken as stack in the dimensions

2. Style - which segregates between two categories, this is considered as bar in the dimensions

Height of the bar is adjusted by the measures in Y-axis.

Is it possible to display the bar graph as required.