How to set in a graph the monthly rates on Y axis and ad a line with the quarterly values

[OnixOnix]

I want to obtain in the power Bi desktop app the following graph but i am struggling to include the month and monthly rates on the same y axis. Could you please help me with this?

[v-jiewu-msft · Accepted solution]

Hi @OnixOnix ,

First of all, many thanks to @lbendlin  for your very quick and effective replies.

Based on my testing, it is impossible to set the monthly rates on Y axis and add a line with the quarterly values. Please try the following methods as workaround:

1.Create the simple table.

2.Create the new measure to calculate the monthly rates.

Month rate = 
VAR month_val = SUMX('Table', 'Table'[Values])
VAR _tota = CALCULATE(SUM('Table'[Values]), ALL('Table'))
VAR result = DIVIDE(month_val, _tota)
RETURN
result

3.Create the new measure to calculate the quarterly values.

Quarter values = CALCULATE(SUM('Table'[Values]), ALLEXCEPT('Table', 'Table'[Quarter]))

4.Drag the two measures into the Line and column chart.

5.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[OnixOnix]

Hello Thnak you for your response.

[lbendlin]

This goes against UX guidelines.  What would be the business benefit of such a display?