Forum Discussion

Post Patron

6 years ago

Showing values in clustered column chart

Hello Guys, I have a task where i need to show Tickets Opened and tickets Closed in Clustered column chart. I have data lik this: 1) Table Name: Report1, Columns: Ticket Opened Date(Date), ...

Need Help

Tips and Tricks

ghouse_peer

Post Patron

6 years ago

Hello MFelix

I have done as said, But i am getting the solution as in the pic.

After doing the above calculations:

1) Selected the both measures in the values.( Tried for both clustered column chart and Stacked bar chart)

2) Selected Dates table in Axis.

3) Selected Dates table in Slicer.

Issue 1: So when i selected the year in slicer i am getting only opened Tickets for 2017. Whereas i have data for all the years for both Opened and closed Tickets.

Issue 2: I need to get all 12 months on the axis.

Kindly Help...

Thank you