Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
  • v-luwang-msft's avatar
    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