Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

You may try to set a visual-level filtering for the graph. 

Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

thanks for your answer. If I do this, the graph only shows data on or after the set date. Since my inventory is based on all data available leading up to this date however, the filter leads to incorrect results.

 

What is working so far is just setting the x axis to specific dates. But since my users cannot change the visuals layout, this is not a very user friendly solution.


Is there any way to allow users to change to X-Axis range? Ideally with some sort of slicer? Or is the X-Axis range onyl available to users with edditing rights?

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?