Bar Graph Interaction with Date Slicer

[hhammeren]

I made a bar graph that summarizes Net Sales by month. I have a year slicer manipulating the graph. What I don't like is that when more than one year is selected the months from all years are combined so you cant distinguish the data.

Below is a visual example when more than one year is selected:

I would LIKE if i could scroll through the years and months seperatly on this bar graph. For example if more than one year is selected have something like this...

Is there anything I can to filter this graph more efficiently?

Thanks in advance!

Hannah

[v-jiascu-msft]

@hhammeren

Hi Hannah,

We need a few steps.

1. Use "Date Hierarchy, keep "year" and "month";

2. Expand all levels down;

Best Regards!

Dale

[hhammeren]

Thank you for your response.

It looks like I may have a different version because I do not have the "date Hierarchy" option. See below.

[v-jiascu-msft]

Hi @hhammeren,

As @ketan10's post said, the column "date" will generate a Date Hierarchy automatically if the data type of "date" is date or date/time.

Best Regards!

Dale

[ketan10 · Accepted solution]

Hi @hhammeren

You can carry out the following steps:

1. Take your Date field instead of the Year/Month field and drag it on the Axis.

2. A Date Hierarchy will automatically be generated (as shown in the sample screenshot below)

3. Just keep the Year and Month fields under that hierarchy. (By default the hierarchy would give you Year > Quarter > Month > Day)
4. Click on any one of the year bars on the visual, it will drill down to the Month level