Chart for waterfall report

[Anonymous]

Hi All, 

I am trying to desing a waterfal report but I come a cross a few chanelnges, 

a list of category ( or axis comes from a table) , I have created a measure for each bar,  I have a master measure that I am matching them with list of category from category table, how ever I still cant get the chart to flow correctly, 

has anyone done something like this or similar to advice ? 

thanks 

[v-chuncz-msft]

@Anonymous,

The requirement is not very clear. You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/Possible-Analytics-function-dynamic-Total-column-in-chart-with/td-p/360533

[Anonymous]

Thanks for the link , it is an interesting solution but not what I am looking for

I have a dataset in powerBI report that I created number of measures  ie Total, Spend, Sales, Customer, EndDateSale, Demand

There is also a table that lists below for ordering the measure on the chart

The chart should look something like this ;

Listtable   List order Total 1 Spend 2 Sales 3 Customer 4 EndDateSale 5 Demand 6

This is a sample scenario I have created

What I have so far is two master measure that one should show the chart value

T Bar =

VAR Total = [Total]

VAR Spend = [Spend]

etc

Return IF ( ListTable[list]),

Switch (

Values ( ListTable[list]),

“Total”,Total,

 “Spend”,spend,

Etc

), Blank()

B Bar =

VAR Total = [Total]

VAR Spend = [Spend]

etc

Return IF ( ListTable[list]),

Switch (

Values ( ListTable[list]),

“Total”,Total,

 “Spend”,spend,

Etc

), Blank()

But the chart not working as I expect,

Hope this make it more clearer

Thanks

[Anonymous]

anyone?