Visualize two category and two values in single chart

[Anonymous]

Hello Chams,

I've below data. 

Job Type	Date	Duration in Minute	Moving Avrage
Amicable	8/1/2021	13.11	13.11
Amicable	8/2/2021	13.13	13.09
Amicable	8/3/2021	13.04	13.09
Amicable	8/4/2021	12.49	12.94
Amicable	8/5/2021	12.13	12.75
Amicable	8/6/2021	12.57	12.75
Amicable	8/7/2021	14.11	12.94
Amicable	8/8/2021	12.43	12.88
Amicable	8/9/2021	12.58	12.84
Amicable	8/10/2021	14.06	12.97
Amicable	8/11/2021	13.47	13.01
Amicable	8/12/2021	12.55	12.97
Amicable	8/13/2021	11.03	12.82
Amicable	8/14/2021	13.13	12.85
Litigation	8/1/2021	13.07	12.86
Litigation	8/2/2021	13.12	12.88
Litigation	8/3/2021	13.22	12.9
Litigation	8/4/2021	13.19	12.91
Litigation	8/5/2021	11.41	12.83
Litigation	8/6/2021	13.32	12.86
Litigation	8/7/2021	13.03	12.87
Litigation	8/8/2021	13.04	12.87
Litigation	8/9/2021	13.22	12.89
Litigation	8/10/2021	13.38	12.91
Litigation	8/11/2021	13.11	13.11
Litigation	8/12/2021	13.24	13.18
Litigation	8/13/2021	13.18	13.18
Litigation	8/14/2021	12.45	13

I need to visualize the above data in a single chart. Could you please suggest me a visual in which my data story would be really clear.

as of now I'm using two chart to display the above data. One is line chart to show the Duration by Job Type and Date and the other one is Clustored Bar Chart to show Moving Avrage by Job Type and Date.

Please take a look at the image what I have done so far.



I tried over lapping the one visual on another but unfortunatly I'm not able to match the X asis and Y axis. It diffres when I'm importing actual data.

I even tried small multiples. That is working fine when I've two Job type. When I've data for only one Job Type then it is leaving blank for other row in small multiple. and that is something which is making it worst.

Requesting you to kindly help in this.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

You could create two measure like below:

avalue = CALCULATE(SUM('Table'[Duration in Minute]),FILTER(ALL('Table'),'Table'[Job Type]="Amicable"&&'Table'[Date]=MAX('Table'[Date])))

bvalue = CALCULATE(SUM('Table'[Duration in Minute]),FILTER(ALL('Table'),'Table'[Job Type]="Litigation"&&'Table'[Date]=MAX('Table'[Date])))

Then create visual :

You could download my pbix file if you need.

Wish it is helpful for you!

Best Regards

Lucien

[Greg_Deckler]

@Anonymous Why not a column and line chart?