Skip to main content
cancel
Showing results for 
Search instead 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

Reply
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
v-chuncz-msft
Community Support
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

Untitled.png

  

 

 

 

 

 

 

 

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors