Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
philthehunter
New Member

Stacked Column Chart Dynamic Start in Y-Axis Issue

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.

1.PNG

 

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

2.PNG

 

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

1 REPLY 1
v-evelk
Microsoft Employee
Microsoft Employee

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.