YOY% for months and Qtr in single column chart

[pratkat]

Calculated YOY% for months, when drill down to Qtr it is showing Average percentage of months. Is there any way we can show accurate value for Qtr in the single visual (Column chart ) for months and Qtr?

If i drill down to Q1 it shows sum or average or... of JAN  (-1.68% ) ,FEB ( 8.34%)  ,MAR (32.14%)   values.  Which is not correct for Q1 with respect to revenue calculation.

E.g., Q1 - It shows 8.75% as YOY%(if we take average), but it should be 9.2%( divide this qtr revenue with last year qtr. )

Appreciate your responses!

[v-huizhn-msft]

Hi @pratkat,

Based on your descriotion, it's hard to understand your requirement well. Could you please create a sample table and list the expected result. I totally understand your data is private, you can create fake data and list the result. So that we can share the solution which is close to your requirement.

Best Regards,
Angelia

[pratkat]

https://www.youtube.com/watch?v=_8fJR2YvqsQ&feature=youtu.be

https://www.youtube.com/watch?v=3bZ3zEFq-40&feature=youtu.be

Hi Angelia,  @v-huizhn-msft

Thank you for the reply. Please see attached videos of excel data and Power BI visual for better understanding.

I am calculating YOY% monthly, and i want to present that Quarterly in the same visual. Monthly revenue fields add up to Quaterly but when it comes to YOY%  it is taking sum / average / min etc.,  of monthly % fields Jan , Feb, Mar in the visual, which is not the correct value.

Q1 YOY% should be 16.06%, not 16.62% as shown in Power BI visual. Is there a way i can present quarterly in the monthly visual.

Have a great day!

Thank you,

Kate