Forum Discussion

flavourabbit's avatar
flavourabbit
Frequent Visitor
8 years ago

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 ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi flavourabbit,

 

Click Editor Queries, click on [Net Sales], [sales Expense], [Production Cost], [Other OH], [EBIT], then click Transform-> Unpivot Columns, table after transforming is like below:

 

Then drag [Attribute] and [Year] to Category, drag [Value] to Y-axis, the result looks like this:

 

 

Regards,

Jimmy Tao

flavourabbit's avatar
flavourabbit
Frequent Visitor
8 years ago

Thanks for the reply.

 

However, unlike the example, the fact table is quite hugh (1M rows, 200 columns) and also has a lot of measures based on the columns. so I think if I create a table with query editor only dedicated for the waterfall chart, then it would be a loss...

 (resulting in slow performance and large file size)

 

Is there any workaround?

(it would be nice to recognize measure names as categorical field contents and use their value)