Forum Discussion
Track inventory level over time
Hi, I am currently working on a project where I want to show the inventory level of certain items on a timeline. For this I have two lists where on holds positive values for when an item is enter...
Hi Anonymous ,
You can create a date range slicer with X axis field Date just as below screenshot, then the user can adjust the date range by option even though they are report viewer...
Best Regards
Hi Anonymous ,
unfortunately this is not really working for me. If I select the range 1.1.2020-31.12.2020 the displayed stock on the 1.1.2020 is 0. For some reason the part "
'Stock'[Datum] <= SELECTEDVALUE ( 'Date'[Date] )" is not working. The measure is not taking numbers before the 1.1.2020 into its calculation.
You seem to have the same issue in the example shared with me. The number on the 1.1.2021 should be 2 bikes + 1 car, since 1 bike and 1 car already entered the inventory in 2020.
What I need is a way to use a slicer or something like it that does not work as a filter on the data/measure but ONLY change the settings for the X-axis.
Is there any way to do this?
Also I am having some issues with the graph that you helped me create. I regularly get the error that "Visual has exceeded the available resources". Is there any way to improve this?