Forum Discussion

hhammeren's avatar
hhammeren
Frequent Visitor
9 years ago
Solved

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 combine...
Need Help
  • ketan10's avatar
    ketan10
    9 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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's avatar
hhammeren
Frequent Visitor
9 years ago

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.

 

  • ketan10's avatar
    ketan10
    Advocate III
    9 years ago

    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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    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