Switch Formula Not Loading in Waterfall Chart

[Anonymous]

I have run into an issue with developing a report that involves switch formulas being used in waterfall charts. My waterfall chart requires unique measures to be used to showcase the impact of several drivers behind a net sales number. This has been set up using a switch formula, with an index table and the measures. Example shown below: 

Waterfall Value=

SWITCH (

VALUES (Account Table'[Index]),

1, Measure 1,

2, Measure 2,

3, Measure 3,

4, Measure 4,

5, Measure 5,

6, Measure 6,

7, Measure 7,

8, Measure 8,

9, Measure 9

BLANK())

While each measure individually is able to calculate quickly, once put into the switch formula several issues arise. In addition, the report allows filters for different groups (i.e. country, brand, period), and if those are selected, the waterfall chart simply fails to work. Any help would be much appreciated.

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[PhilipTreacy]

Hi @Anonymous 

Please supply your file.  This is almost impossible to disgnose without seeing your data and code.

regards

Phil