How to plot quarterwise measure on line chart with month-based X-axis

[Varishtha]

I have a measure(say "SK4") which holds significance only if calculated quarter wise. 
Now I want to create a new measure (say "BK", where BK=sales*SK4). 

I want to plot this "BK" measure on a line graph, where X-axis will be monthwise.

Now since the x-axis is in months, the value SK4, hence BK4, will be calculated monthwise. But, I want that while calculating BK, it should consider quater wise value of SK4 , not month wise. 

How can I achieve this? 

[v-heq-msft · Accepted solution]

Hi @Varishtha ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create measures

SK4 = 
CALCULATE(
    AVERAGE('Table'[Price]),
    ALLEXCEPT(
        'Table',
        'Table'[Quarter]
    )
)

Total = [SK4]*SELECTEDVALUE('Table'[Sales])

Final output

Because measure takes effect based on context, not only do you need to place the date column on the x-axis, but you also need to place the quarter column on the x-axis as well

Best regards,

Albert He

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

[Varishtha]

Hi @v-heq-msft , 

Thank you. This was really helpful.