A business user came to me asking “how can I get a vertical line on Line Chart in Power BI like my Excel report?”. I was like, “It’s straightforward. We have this analytics pane which lets you add so many types of lines 😊 “. But, quite quickly I understood, I cannot draw a vertical line as we do in Excel or SSRS.
Oftentimes we have data in a format that is not suitable for creating visualizations in Power BI, for example, pivoted data. However, we still want to work with that data. Let us explore this in more detail.
Suppose we have a table of data representing units sold of some product across USA and Canada in the following format:
Mobile cross-platform solution for visualizations of Warehouse Management System module of the Microsoft Dynamics NAV.
•Simple setup process and changing WMS in Microsoft Dynamics NAV
•Create/modify/delete Locations, Zones, Bins, Racks – new functionality
•Fast reorganization of warehouse structure
•User defined functions of selecting bins on location scheme
At the end of every month, we will inevitably get some questions on why their inventory valuation figures does not match the G/L inventory account. We would investigate and find out why and provide solutions on how to fix them.
Some of the reasons are pretty common so I’d thought I compile a list of reasons why your inventory valuation does not match your general ledger, and how to fix them.