Forum Discussion

apcor's avatar
apcor
Frequent Visitor
6 years ago

Idea for Waterfall Chart

Hi, I have 2 tables, the first with the transport orders and their respective planning date (theoretical)   and the second with the history of the transport order status on 01/27 and 01/28. ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  apcor 

To my knowledge, it could not achieve in waterfall chart for now, you could only drag one measure into Values of this visual.

Maybe you could just use table visual or matrix visual for your requirement.

 

Regards,

Lin

apcor's avatar
apcor
Frequent Visitor
6 years ago

Hi Lin,

I made one last attempt to make the waterfall graph, I did this:

I built the following table:

 

 

Then I created a measure that assigns the values I want to each "Factor-Component" pair to create the waterfall graph:

 

 

So far so good, check that the assigned values are correct, the problem is that when I want to create the waterfall graph I get this error:

 

 

What I want to achieve is something like the figure below, I did this by copying the values to another table in a new power bi file to check if the error came from the table structure:

 

Thanks for the support, I really appreciate it

 

Regards

 

Anthony