Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 -
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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |