Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |