Forum Discussion
Distribute uniformly Increase In volume
Hello All,
Is the following problem possible to solve? If this format is not the correct to approach the issue then what format/visual should I approach?
The problem is the following.
I'm creating a report in Power BI that includes a Line and Clustered Column Chart. The X-axis (Columns) displays a measure calculating the average inventory turns over the last 4 years. This measure divides the average volume shipped over those 4 years by the asset's monthly bin capacity. These inventory turns are represented by the columns in the chart. The columns are displayed monthly.
I have a table with all the necessary dates and all types of data, including Month number and Month description.
On the other hand, the line in the chart calculates what the inventory turn would be with a percentage increase. This increase is calculated by multiplying the percent increase by the average volume of the last 4 years. Then, I take that increase, divide it by the Bin Capacity, and get what I call "forecasted Inventory Turns". The goal is that the line can display a forecast in which you can see what the turns per month will be with a volume increase.
However, the issue is that the increase applied is not realistic because it's being applied equally to all months in a linear manner. This approach doesn't reflect how business operations work, where increases are typically targeted at specific months.
What I need is a solution that allows me to choose specific months or a range of months where the increase should be applied. When these months are selected, the Line should dynamically adjust so that only those months reflect the increase, shaping a new line accordingly while keeping the rest of the chart unchanged.
Do you think this is possible? I have all the measures and data necessary. I just haven't figured out a way of making it work.
Thank you,
Pablo F
Hi Clara,
Thank you very much for your response. It wasnt quite the solution that I was looking for. However, it surely guided me in the correct path to achieve what I wanted and solve the problem.
In a simple way, what I did was that I created a Numeric paramter for each month. After that I I used a formula to bring the value that I wanted to each month IF the paramter was selected. If not true that value should come as 0.
Thank you
Pablo Franco Mesa
2 Replies
Hi Anonymous ,
Perhaps a field parameter can help you out. Field parameters allow users to dynamically change the measure or dimension being analysed in a report. This feature helps report readers to explore and customise the report's analysis by selecting different measures or dimensions that they are interested in. More details can be found in the documentation: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
If this doesn't solve your problem, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Clara,
Thank you very much for your response. It wasnt quite the solution that I was looking for. However, it surely guided me in the correct path to achieve what I wanted and solve the problem.
In a simple way, what I did was that I created a Numeric paramter for each month. After that I I used a formula to bring the value that I wanted to each month IF the paramter was selected. If not true that value should come as 0.
Thank you
Pablo Franco Mesa