Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Satyajit537
Frequent Visitor

Sawtooth decay charts in Power BI

Hello!, 
I am trying to create a cyclic graph in Power BI with a condition added upon it. 
I have the following data structure. 

DayStarting Amount Safety StockUnits per DayLot SizeOn Hand Inventory
080055030200800
180055030200770
280055030200740
380055030200710
480055030200680
580055030200650
680055030200620
780055030200590
880055030200560
980055030200730
1080055030200700

The objective is to generate a decay curve with saw tooth like features. The starting on hand stock (800 units) decays at the rate of 30 units per day. The day on which it goes below the safety stock value, lot size number of units are added back to the system again. This cycle continues. The objective is to create a column like the last column (on hand inventory) which tracks these movements and shows the current on hand inventory at any given time. 
The final graph created would look something like this. (The dotted lines should indicate the safety stock level in my case).

 

Satyajit537_3-1718364871660.png

 



4 REPLIES 4
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Edited the post as per your suggestion. Would be helpful if you have any leads for the solution

You cannot create semi additive columns in Power BI.  The only way to do this is in Power Query with List.Accumulate.

 

How many days in advance do you need to calculate?

What do you do with the chart once it is computed?

The safety stock numbers are generated in dax itself. So my current requirement involves the use of DAX based solutions. But if it cannot be done then I will find some alternative. 

My plan was to create a chart that tracks the on hand inventory value by each day 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors