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?
A Typo for premium icon in Mobile app
A Typo for premium icon in Mobile app Hi, Team Power BI Mobile app version(iOS): 32.1 I have several workspaces with fabric capacity including trial. I create a workspace with F2 capacity and then I can find the premium icon(diamond). When I try to navigate workspaces in the mobile app, I can’t find the icon. It’s not synced. Thanks, Hong
Mobile app not showing arrow characters
I have a few card visuals showing arrows in the reference labels, these are corect shown in Power BI Desktop (june 2024) and in the service. But in the mobile app (both in landscape as portrait mode) the arrows are not shown correct. In desktop and the service: in the mobile app: The used Font is Segoe UI Size 12 The used characters are: VAR UpArrow = UNICHAR(129137) VAR DownArrow = UNICHAR(129139) I hope this is enough info to solve the issue. Best regards, Twan Verdonschot
Paginated Report - E-mail subscription excel - formatting issue on mobile
Dear fellow Power BI enthusiasts. I have created a Paginated Report that i want to send as a E-mail subscription with an Excel file attatched. It works perfectly on the PC when opening the excel file in the e-mail. When i open the excel file on the phone the formatting on the numbers is odd. From mobile: correct formatting (manual excel file): Has anyone had the same issue or has a solution to the issue ? Thanks. Best regards Mathias
BUG: HTML code " " is displaying instead of blank values when n show as table on mobile app
Hi Community, Recently I found the following BUG on the mobile app. The HTML code: " " for blank/space is being displayed when the value is supposed to be "BLANK". The error happens when I use the "show as table" on pbi mobile app. On PBI desktop and service the values are showing as expected (not showing anything) but when the user opens the report using PBI mobile app and clicks on "show as table", instead of showing "" (nothing), the table is showing html code. To be clear: I'm not using any HTML as any source of data. The measures are simple ifs like: current year = VAR cumulative = CALCULATE( [measure] ,KEEPFILTERS( YEAR(fact_table[date]) = YEAR(TODAY())) ) RETURN IF( VALUES(Date_Dim[Day]) > [Max Current day] , BLANK() , cumulative ) Thank you in advance!Filter pane on iPhone doesn't show Apply Filter button
We have a report that is set to show the Date filter for the report in the Filter pane on Desktop. On Mobile, the Filters pane correctly shows the date filter, but the Apply Filter button is missing when doing this from an iPhone (it works properly on Android):
