Forum Discussion
Waterfall Chart using multiple measures
Hi,
Yes, you can do it via a workaround in DAX formula and a control table.
1. Create a table with matching "measure" name:
2. Create an additional measure for your waterfall chart, you may apply + or - for your measure to get the waterfall sentiment:
Waterfall value =
SWITCH (
SELECTEDVALUE ( Table1[Index] );
1; +[Measure 1];
2; +[Measure 2];
3; -[Measure 3];
BLANK()
)![]("C:\Users\YongC\OneDrive - BDF Group\Documents\Data\Support\PowerBI\PowerBI_20190312.PNG")
3. Apply the new measure in your waterfall chart, with the category based on the table field created (Note that you need to sort it via the category, use hierarchical drill-down if needed):
Cheers!
Thanks a lot for this. How can I make the color of starting bar and end bar same? basically i want to show 1st bar as begining value. then all components and then fianlly end value. I want to set these 2 bars as total and different color from increase/decrease
I have the same question
Hi..Thanks for this solution. But how can you remove Total bar?? In my case, total bar is undesirable...moreover, can we change the colour of first and last bars to keep in lookalike?
this is my question!!
Really good idea and perfect instructions!
Are you able to confirm that the idea posted above worked succesfully? I haven't had time to revisit this, but if it worked for you I will mark it as the solution.
How could we remove total bar in the end of this chart?
Anonymous wrote:How could we remove total bar in the end of this chart?
Have you been able to remove the "total" bar from the chart?
Hello,
I have seen that the "total" column can "disappear" by using a breakdown field; however, with this solution, how would you create that breakdown field?
Thanks!
Great solution cyongt_bdf,
One small improvement I figued out while trying this is to make an additional column in the new table. You will use this new column field as your Category. This field be whatever you want your X-axis titles to be. For example, "1: Measure 1", "2: Measure 2". This way you do not have to drill down to get the x-axis to look the way you want, and you can still make the order of the items static.I used a DAX formula like the following to make this new column:
X-Axis Titles = 'Table1'[Index]&": "&'Table 1'[Measure]Anonymous How does this make it static?
For me based on this methodology, the columns in the waterfall shift based on whether the figures are accending or descrending. Can you share an example?
it doesnt change based on values if you create an index. Once you assign order of the index, the chart always dispalys in that order. worked for me.
Thank you a lot for this amazing solution!
I have just tried it out and it works perfectly
That's prety cool Anonymous, thanks
We dont need the column with the measures name in the table, just one with the names that we want in the axis, sorted by the index column.
In the graph we only need that name column, and the graph sorted by that column. No need for drilldown
Any ideas on how to change he colors? Maybe with the breakdown field?This is amazing. Thank you!
Anonymous Hi, I know this is really old. Do you have the sample pbix file? I am not following the. Create a table with matching "measure" name. Thank you
