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...
  • 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.