I am attaching pbix file, i am working on variance analysis between one year to another year and developed a format for waterfall chart using Sam example of financials format.
I have developed selected variable dax and the information comes correctly based on the format designed.
When iam using the information on the waterfall visualization the visual is not appropriate, i do not want to see the total and the bridge items should show before Net sales 2019, the sequence should be based on the index i developed. So that i can see- Net Sales 18, Price, Volume, Cost and Net Sales 19. Do not worry on the nomenclature.
Appreciate help, attached pbix fileHelp on Waterfall Chart.pbix (48.5 KB)