Stacked Column Chart Dynamic Start in Y-Axis Issue

[philthehunter]

Hello Guys,

I have a requirement to show in the stacked column chart value of 0.0 when the value in the chart is zero.

One way to do it is to make the chart bigger and adjust the value in the start. However, every month I have a different set of data. So my problem is how to set the start in the Y-axis dynamically. Or any DAX to solve the issue?

At Start 11.5 value of zero in the chart is not showing.

At Start 12.6 value of zero (0.0) in the chart is showing.

Is there a way to set the start dynamically based on the data I passed in the chart since every month data varies.

Any other solution to show the zero? Any other object to use other than stacked column chart to satisfy the requirements.

Thank you in advance for your help. 🙂

Regards,

Phil

[v-evelk]

Hi Phil,

Do you use standard Stacked Column Chart?

If so, I suppose it is better to solve your question with DAX because standard visuals are updated rarely. 

To get assistance with DAX you can write into Desktop thread.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com