Forum Discussion
Daily shipment tracking
Power BI community,
I need to track daily shipment performance versus forecasts by multiple departments.
Here is a sample data.
Here is the expected outcome with 4 main sections.
1. MTD (month to date) actual shipment performance by brand in absolute and shipment/day as well as a linear projection of full month volume, which I was able to create.
2. Operation full month forecast, in absolute value, variance vs the linear projection (from 1), operation forecast shipment per day, and necesarry MTG (month to go) shipment/day to meet operation forecast
3. Same as 2, but with sales forecast
4. Finance forecast, which I was able to add.
Since Operation and Sales team have a weekly forecast, I would like to have a selection pane next to the date slicer to choose which version of forecast I want to do comparison against.
In below case, it is Feb 1 forecast, but if I select Feb 8 forecast, I need Ops and Sales forecast number to change.
Then, I would like to highlight risk in red.
IF MTG vol/day is higher than MTD vol/day, highlight in red.
IF full month forecast is higher than the linear projection, highlight the variance in red, as per below.
Lastly, to make it easier for viewers to see the data,
To highlight the headers for operation, sales and finance section in different colors as per below.
Support is much appreciated!
- Anonymous1 year ago
Hi hidenseek9 ,
Based on your description, you can use a custom format to achieve this. Since the data you provided is not viewable, you can provide more detailed data and desired results so that we can help you more quickly. Please withhold sensitive information in advance.Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
- AnonymousNot applicable
Hi hidenseek9 ,
Based on your description, you can use a custom format to achieve this. Since the data you provided is not viewable, you can provide more detailed data and desired results so that we can help you more quickly. Please withhold sensitive information in advance.Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- v-karpurapudCommunity Support
Hi hidenseek9
Could you please confirm if your query have been resolved the solution provided by Anonymous ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you