Display % in Matrix visual with decimal number formatting - within multiple filtered contexts v2
Hello DAXperts, I have posted a similar issue before here and that was resolved perfectly. This one is a different problem as I have different formulas in different contexts. I have a matrix visual showing data from a "MainData" table. I have been able to display % numbers for selected rows with a decimal formatted matrix. This works for the single monthly columns (measures), but does not work for the Full Year (custom measure called "Total"), and also does not work for the corresponding "Budget" full year total (also a custom measure). I want these two columns/measures ("Total" and "Budget") to show % values at selected rows consistent with the other columns in the matrix. Currently, the decimals also looks to be incorrect. Ideally, the Gross Profit % or any percentages should be divided by Revenue like the other columns. Ie. Gross Profit % = Gross Profit / Revenue Earnings Before Tax % = Earnings Before Tax / Revenue Please see below image & attached PBIX file. Any suggestions or workarounds much appreciated.Display % in a Matrix visual that has decimal number formatting - within multiple filtered contexts
Hello DAXperts, I have a matrix visual showing my data from a "MainData" table. I have been able to display % numbers for selected rows while the rest of the matrix is decimal formatted. But this only works within certain filtered contexts based on the selected slicers. Ultimately, I have a Profit & Loss report, I want this report to show the correct calculated % values for the "Gross Profit %" row. Currently, the data does contain the correct decimal values for the % equivalent number for "Gross Profit %". But the numbers are correct when only a single Business Unit is selected on the slicer. Ideally, the GP% can be calculated by use of a measure or something similar (but I have not gone this route): GP% = DIVIDE( CALCULATE( [PL], 'MainData'[L1] = "Gross Profit", CALCULATE( [PL], 'MainData'[L1] = "Revenue" ) ) The measure I really need help with is [ActualsPL w %] or [ComparisonPL w %]. See below image and attached PBIX file. Any suggestions or workarounds is much appreciated!
