Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi There
Fairly new to PowerBI, but a long time user of waterfalls.
Instead of getting a very wide waterfall with all the variances across the graph, even those that at minor, I would like to show those that are material (variance greater than 5,000 (plus or minus) and % variance greater than 2.5% (plus or minus)) as single movements and then all the smaller ones as "Other".
If I filter out the smaller ones the total movement in the waterfall is does not reconcile to the total movement.
Is there any way of getting the smaller variances to group into the catch-all "Other" group as a coded solution?
Thanks in advance.
@BryanSt,
Could you please share dummy data of your table and post expected result here?
Regards,
Lydia
I have attached the two graphes and the data pasted below. My accounts come from a formal Chart of Accounts and there is no "Other" in that data. I usually have a multi card report above the graph which is dynamic as it works on the highlight.
If the full chart (default) then the card can have a different movement shown that the filtered graph if there are many small variances.
Acct_Desc | Actual | Budget | Actual - Budget Value | Actual - Budget % |
Administration Expenses | -9000 | 0 | -9000 | -100.00% |
Building Maintenance - Expense | -6000 | 0 | -6000 | -100.00% |
Electricity & Water - Expense | -1000 | 0 | -1000 | -100.00% |
Loss on disposal of fixed assets (land) | -951000 | 0 | -951000 | -100.00% |
Grants & Subs Exp - Recurrent (by GG) | -300000 | -75000 | -225000 | -75.00% |
Services & Contracts Expense - Professional Services Not Elsewhere Classified | -138000 | -112000 | -26000 | -18.80% |
Services Rendered | 2952000 | 2592000 | 360000 | -12.20% |
Metropolitan Region Improvement Tax Act 1959 | 24480000 | 23643000 | 837000 | -3.40% |
Rent revenue | 1606000 | 1572000 | 34000 | -2.10% |
Interest Revenue | 1838000 | 1800000 | 38000 | -2.10% |
Amounts Provided to Fund Services | 1511000 | 1484000 | 27000 | -1.80% |
Resources received free of charge. | 113000 | 112000 | 1000 | -0.90% |
Depreciation of Fixed Assets | -824000 | -875000 | 51000 | 6.20% |
Service Delivery Agreement - Expense | -10147000 | -11505000 | 1358000 | 13.40% |
Revenue - Other | 305000 | 412000 | -107000 | 35.10% |
Doubtful Debts - Expense | 0 | -5000 | 5000 | 100.00% |
Land tax expense | 0 | -15000 | 15000 | 100.00% |
Profit on disposal of fixed assets (land) | 0 | 1250000 | -1250000 | 100.00% |
Sale of Goods | 0 | 2000 | -2000 | 100.00% |
All Other Expenses | -2000 | -41000 | 39000 | 1950.00% |
Bumb, also looking for solutions to dynamic sorting small deviations into an other group based on relative size (% of deviation) instead of an actual number.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |