Forum Discussion

lian96022's avatar
lian96022
Frequent Visitor
7 years ago
Solved

Stacked Bar Chart and Legend

I have a stacked bar chart where I would like the legend to use a date field. When I drag it to the Legend and click on "Date Hierarchy" it shows me the year but not the month. How do I get it to sho...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi lian96022 

    Create a month column, add this column in the legend

    month = MONTH([date])

    Add [year] in the slicer, so you can view the visual more clearly.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lian96022's avatar
lian96022
Frequent Visitor
7 years ago

It does not reflect the same options. When I drag my date to "Axis" I get all the options. However when I drag it to "Legend" I only get Year...which I am wanting to get Month.

 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi lian96022 

Create a month column, add this column in the legend

month = MONTH([date])

Add [year] in the slicer, so you can view the visual more clearly.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.