Sales Vari % can display on table but not chart ?

[admin11]

Hi All

I have a Table , it can display YTD and LYTD sales and Sales Vari % :-

When itry to plot the chart it can display YTD and LYTD :-

Now i try to plot the Sales Vari % only , it does not display . Can some one advise me where go wrong ?

Paul Yeo

[admin11]

Hi

[Ashish_Mathur · Accepted solution]

Hi,

In the Source, delete the Source_temp column.  Revise the Sales_YTD measure to:

Sales LYTD = 
var _max = date(year(today())-1,month(today()),day(today()))
return
TOTALYTD([SALES_],dateadd('DATE'[Date],-1,year),'DATE'[Date]<=_max)

[admin11]

@Ashish_Mathur 

Why I cannot tick your answer is correct ?

[admin11]

@Ashish_Mathur 

Thank you it work.

[Ashish_Mathur]

You are welcome.