Forum Discussion

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost 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
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi ghouse_peer ,

 

Create a relationship between the calendar table and the Opened Date and the Closed Date. depending on the order you make it one will be active and the other inactive then just create the following measures:

 

Open Tickets = COUNT(Report1[Ticket Number])

Closed Tickets = CALCULATE ( COUNT(Report1[Ticket Number]), USERELATIONSHIP(Report1[Ticket Clodes Date],Calendar[Date] ) )

 

Now place both measure in the chart using the calendar as the X-Axis.

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost 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

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi ghouse_peer ,

     

    Can you share the measure formula and an image of your relationships?