Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

avatorl

Analytics: Y-Axis Constant Line bug

Submitted by Impactful Individual on ‎12-07-2021 09:20 AM

This happens when I add Analytics: Y-Axis Constant Line to the stacked column chart using a measure for Value field, but I assume it's relevant to other chart types.

 

The visual displays 0% line on the bottom of the column despite the measure used for the Value field returns BLANK(). Also having Y-Axis Start greater than 0% doesn't fix the problem. It still shows the 0% line on the bottom of the column, even when axis Y starts from much bigger value (e.g. 75%).

avatorl_0-1638897516194.png

 



 

 

Status: Accepted

Seems like could find this issue in Power BI Desktop.

If firstly create a constant line in the visual with the blank value measure, the line would not show in the visual;

if create the constant line again in the visual with the blank value measure, it would show the 0 value line.

 

Have submited this issue internal to confirm(ICM: 277149378), would update here as soon as possible if there is any progress about this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
6 Comments (6 New)
Comments
v-yingjl
Community Support
Community Support
‎12-07-2021 09:57 PM
Status changed to: Investigating

Could not reproduce it in my side as far as my test. If Y-axis starts greater than 0 and use blank() measure to set constant line value, the Y-axis should back to 0%.

vyingjl_0-1638942875818.pngvyingjl_1-1638942886971.png

 

Perhaps you can update to the latest version of Power BI Desktop to check it again. If it still has the same issue, you can consider sharing the steps to reproduce this issue or a simple sample file which could reproduce it for further.

 

Best Regards,
Community Support Team _ Yingjie Li

avatorl
Impactful Individual
Impactful Individual
‎12-07-2021 11:08 PM

Thanks for the answer. I'm not sure what happens with Axis Y on your side, but I think you actually reproduced the problem.

Ignore the Axis Y. It's not critical to reproduce the porblem.

Normal behaviour (I tried line chart visual and it works correctly): if a measure used for Value returns BLANK() then there is no line on the graph. It's correct, BLANK() is not 0%. BLANK() means no data, no line.

Bug (stacked column chart): if a measure used for Value returns BLANK() then there is 0% line on the graph.

P.S. I'm using the latest version of the Power BI Desktop.

v-yingjl
Community Support
Community Support
‎12-10-2021 12:51 AM
Status changed to: Accepted

Seems like could find this issue in Power BI Desktop.

If firstly create a constant line in the visual with the blank value measure, the line would not show in the visual;

if create the constant line again in the visual with the blank value measure, it would show the 0 value line.

 

Have submited this issue internal to confirm(ICM: 277149378), would update here as soon as possible if there is any progress about this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

aquan
Frequent Visitor
‎04-27-2022 07:54 PM

Hello

 

Any update on the mentioned issue? (ICM: 277149378)

 

Is it currently being worked on/recognised as a bug?

 

Regards

Phil

nkpenta
Microsoft Employee
Microsoft Employee
‎10-10-2022 03:11 PM

Running into same issue even on line plot.

nkpenta
Microsoft Employee
Microsoft Employee
‎10-10-2022 04:05 PM

please refer to the temporary solution i came up with. 
Re: dynamic constant line for blank value - Microsoft Power BI Community

Idea Statuses