cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Chart for waterfall report

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

3 REPLIES 3
Community Support

@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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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
Not applicable

anyone?