Stacked Column Chart Dynamic Start in Y-Axis Issue

philthehunter — Wed, 17 Apr 2019 03:45:33 GMT

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

Re: Stacked Column Chart Dynamic Start in Y-Axis Issue

v-evelk — Thu, 25 Apr 2019 14:55:29 GMT

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

topic Re: Stacked Column Chart Dynamic Start in Y-Axis Issue in Developer

Stacked Column Chart Dynamic Start in Y-Axis Issue

Re: Stacked Column Chart Dynamic Start in Y-Axis Issue