Urgent! Question related to "line & Stacked Column Chart" and Waterfall Chart

[Bwong]

Hi All 

I have some urgent questions in related to chart visualisation. I still new to the BI, but got a project to finalise ! I hope I can get some help on the visualisation part ! Thanks so much for your time !

(1) Line and Sacked Column Chart 
      I found I am unable to use the stacked column chart properly at all. I wanna have one more category on the column chart of Jan to June, please if any one can guide me to the right direction to use this.  
    

(2) Waterfall chart
     I have full set of data on the breakdown, but I dont even come up the a solution to present the waterfall chart by product with both beginning and closing balance and show the movement in between. Please kindly advise. 

      my set of data looks like this : 
                        beginning Balance  Closing balance    Movement 1  Movement 2 Movement 3    Total movement 
      Product 1       200                                 260                          1 0                   20                 30                60      

      Product 2       100                                 160                          1 0                   20                 30                60  
      product 1       400                                 460                          1 0                   20                 30                60     

(3) Apart from that, any advise to a fancy visualisation of result or website you commend me to take a look ! 

Thanks so much in advance !!!! 
B 

[v-frfei-msft]

Hi @Bwong,

(1) Line and Sacked Column Chart 

Answer:You can add the category to the Legend.

(2) Waterfall chart

Answer: you can use Ultimate Waterfall to have a try.

(3) Please search all kinds of custom visuals from the market place. such as Mekko chart.

For more details, please check the pbix as attached.

Regards,

Frank

[Bwong]

Hi @v-frfei-msft

Your reply are awesome !! Especially on the waterfall chart. 

Just on line and stacked Column Chart, the question is if use 2 line charts together, it does not work with the add-on stuff on the column chart .....

I will search around with the visuals !

Thanks so much again ! 
B

[v-frfei-msft]

Hi @Bwong,

What do you mean "if use 2 line charts together, it does not work with the add-on stuff on the column chart"?

Could you please check whether using the report tooltip can work around? Do turn the two options on as the picture below. For more details, please check the online document. 

Also please find the pbix as attached for your reference.

Regards,

Frank

[Bwong]

Hi @v-frfei-msft

Thanks so much for following up on these. 

For "line and stacked column chart", i mean it does not work with the breakdown on the column chart, like I cannot do one more colour on the blue bar. I cannot add it to the visualisations field as in picture 1

Besides, I did try with ultimate waterfall chart, but how do you how movement 1, movement 2 and 3 with only 1 filtered product. 

Thanks so much !

B

Picture 1