Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Line chart challenge

(Edited) Hi,   I intend to create a single line chart that visualizes 2 set of values - OValue and Forecast_Value. (both in different tables)   The user is given an option to choose a Product ID...
Need Help
Tips and Tricks
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Anonymous ,

 

First create a date table as slicer;

Then create a measure a below:

Measure = 
var _date=SELECTEDVALUE('Date table'[Date])
Return
IF(MAX('Table'[Date])>=_date&&MAX('Table'[Date])<=_date+10,SUM('Table'[Value B]),IF(MAX('Table'[Date])<_date&&MAX('Table'[Date])>=_date-10,SUM('Table'[Value A])))

And you will see:

 

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!