I have actuals in a fact table that is connected to date table. The fact table is at Month and Year so I had created new column at power query to generate start of month date column from existing year and month columns… Joined fact with date on dates. Now I am trying to plot my actuals on Line Chart
Scenario : I would like to select a Year Month on Slicer and want to show/display Line Chart from start of year till that Selected Year Month.
The below doesnt seem to work
VAR SelectedYear =
SELECTEDVALUE ( dim_date[FiscalPeriod] )
VAR Result =
CALCULATE ( sum(vw_fct_inventory[actual])/1000000, dim_date[FiscalPeriod] <= SelectedYear )
RETURN
Result
There’s a certain type of slicer that perfectly fits your requirement which is the less than or equal to slider you can achieve this by changing the slicer type on the dropdown menu
Hi @Archer, did the response provided by @m.abdelkarim help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Hi @Archer, we’ve noticed that no response has been received from you since the 16th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Archer, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
