Forum Discussion
Anonymous
5 years agoNot applicable
Visualize two category and two values in single chart
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 ...
- 5 years ago
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
Community Champion
5 years agoAnonymous Why not a column and line chart?