Forum Discussion
Bar Graph Interaction with Date Slicer
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
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
4 Replies
Hi Hannah,
We need a few steps.
1. Use "Date Hierarchy, keep "year" and "month";
2. Expand all levels down;
Best Regards!
Dale
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.
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
