Dynamic measure formatting (preview) not displaying stacked bar chart totals in correct format
Problem: Stacked bar charts dont display totals in the correct format when using the new preview feature dynamic formatting for measures. See the image below In this example the measure is dynamically formatted to display as a percentage, which it does on the individual segments of the bar. But on the totals in the tooltips it always shows a different format (possibly the original format), and when enabling the column totals it shows a combination of formats as seen at the top of each bar. Measure: Test Measure = COUNTROWS('My Table') Format: "0.0%;-0.0%;0.0%" Please could you help with identifying the issue? I cant turn on column totals on this visual as it is. Thanks
Dynamic Inventory Reconciliation: Aligning Opening and Closing Balances in Power BI
I have created an Inventory Reconciliation report that includes a Year slicer. The report's main visual is a matrix with the following rows: Opening Inventory Purchases Sales Closing Inventory (Calculated) On-Hand Quantity The Closing Inventory (Calculated) is determined using this formula: Closing Inventory (Calculated) = Opening Inventory + Purchases - Sales The matrix has Months set on the Columns. For example, if the year 2023 is selected: January’s Opening Inventory is calculated using the following DAX formula: Opening Inventory (Q) = CALCULATE( [On-Hand Qty], PREVIOUSMONTH('Calendar (On-Hand)'[Dates]) ) For February, the Opening Inventory should use January’s Closing Inventory (Calculated) or the previous month's Closing Inventory. Currently, the Opening Inventory row uses its formula to calculate results, which might lead to inconsistencies. I believe the Opening Inventory should instead depend on the Closing Inventory (Calculated) from the previous month. What would be your solution?
