Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

CY vs PY in Time Series Chart Using Calc Groups

So I'm playing around with calculation groups and they seem good but I've hit a barrier. I want to display a single measure split into CFY and PFY shown as two lines on the same time series chart. Th...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello Anonymous,

 

Can you please try: 

Sales Measure = SELECTEDMEASURE()

Sales CFY = 
CALCULATE(
    [Sales Measure],
    'Time Intelligence'[Time Segmentation] = "CFY"
)

Sales PFY = 
CALCULATE(
    [Sales Measure],
    'Time Intelligence'[Time Segmentation] = "PFY"
)

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Sahir,

 

Thanks for this and I see where you're going but the DAX provided doesn't appear to be valid and results in an error. I think also, you'd need a slicer to switch between the two selected measures. I already have another calculation group that enables this switch functionality but it only allows one measure/Calculation item in the time series chart at one time. I'm wanting to have both the CFY and PFY as two separate lines as if they were two independent measures. But just using a combination of a single measure and two calculation items.

 

After looking into this, I suspect it's not possible tbh. Let me know if I've misunderstood though!

 

Thanks,

 

Luke