Forum Discussion

kritilodha's avatar
kritilodha
New Member
3 years ago

Waterfall chart issue

Hi,

 

I have created a waterfall chart with beginning and ending value as well as the bridge showing variance. Looks like this - PyQ and CQ are Previous Year Quarter and Current Quarter market share for a particular company. And the bridges in between are the share variance related to the segment - commercial and consumer.

The above chart works fine when I have more than 2 data points in between the beginning and ending value (like in the above chart where there are values for both commercial and consumer). However, when I filter out on a particular country which has only consumer data, the chart doesn't show me the market share for the company - it just shows me the variance - look below - 

The formula that I have used is this - 

 

Waterfall Bridge Share change SEGMENT =
VAR ShareLY = CALCULATE([Company Share %], PARALLELPERIOD('Calendar'[Date],-4,QUARTER))

RETURN

SWITCH(SELECTEDVALUE('Walk CQ'[Walk]),"PYQ",

SWITCH(SELECTEDVALUE(PC[Segment]),"Consumer",-1*[Segment ShareVariance], "Commercial",-1*[Segment ShareVariance],

ShareLY
),
"CQ",
SWITCH(SELECTEDVALUE(PC[Segment]),"Consumer",0,"Commercial",0,
[Company Share %]))
 
Can someone pls help me sort out the issue I am facing in the second chart? I would like to be able to see the PYQ and CQ market share along with the share variance for consumer. What needs to be edited in the formula?
 
Plssss help!!!!
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi kritilodha,

    Perhaps you can try adding '+0' in your formula statements. They will force convert the blank value to zero to keep the calculations.

    Regards,

    Xiaoxin Sheng