Forum Discussion

SriGaG1's avatar
SriGaG1
Icon for Helper II rankHelper II
3 years ago
Solved

Average Constant line creation is not working

I have created a line graph which is filtered using a date range picker. . And the chart is getting dynamially changed when we are back dating the values. Aditionally I needed an average value for La...
data protection
Need Help
Show and Tell
Tips and Tricks
  • HoangHugo's avatar
    HoangHugo
    3 years ago

    Hi

    I think it is due to use ALL function, that will clear all Date filter in your whole page. So, try this one

    Avg sales = CALCULATE( IFERROR(
    [LY Sales]/[Measurecal],
    BLANK()
    ), ALLSELECTED('Date'[Date]))

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
3 years ago

Hi, this maybe for your Date format, make sure Date column in your two table is same format. 

In the line visual, you choose "Continous".

  • SriGaG1's avatar
    SriGaG1
    Icon for Helper II rankHelper II
    3 years ago

    Thankyou very much. I think its now working. Means alot. and you saved the day.. Lets close this off.

     

    Thank you again