Forum Discussion
Waterfall Chart using multiple measures
Hello, I know this must've been an old topic in Business Intelligence. However, I didn't find any idea to realize what I'd like to achieve. The thing is I'd like to create a Waterfall Chart ...
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!
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?
