cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gabriela Regular Visitor
Regular Visitor

Histogram visual doesn't display negative values

Hi,

I've been using histograms (from custom visuals library) for quite some time. They were working perfectly on desktop PowerBI and also in web. 

 

Unfortunately in the latest version of PowerBI the histogram doesn't display negative values (as you can see in the picture on the right).  Normally, I'd go for an R visual but this is no longer supported in the PowerBI version I have.

 

I'd appreciate any suggestion how to deal with this problem.

 

histogram_problem.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabriela Regular Visitor
Regular Visitor

Re: Histogram visual doesn't display negative values

Hi all, just to confirm, MSFT solved the issue with negative values in the histogram visual in the latest update (December 2017).

 

9 REPLIES 9
Moderator v-yuezhe-msft
Moderator

Re: Histogram visual doesn't display negative values

@gabriela

I make tests in October update and November update of Power BI Desktop, histogram charts show as same as yours, the negative values don’t show in the left side of x-axis.

In what previous version of Power BI Desktop did you create the histogram and histogram chart displays negative values as shown in your first screenshot?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gabriela Regular Visitor
Regular Visitor

Re: Histogram visual doesn't display negative values

@v-yuezhe-msft,

thanks for looking into this. I'm not sure how can I check the version in which histograms worked (can I?) but after last update to version 2.51.4885.701 64-bit (October 2017) it stopped working. 

 

When I tried manually fix the x scale display option it automatically changes to 0.

 

 

Moderator v-yuezhe-msft
Moderator

Re: Histogram visual doesn't display negative values

@gabriela,

I get same result in May update of Power BI Desktop, negative values also don't show in the left side of x-axis.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gabriela Regular Visitor
Regular Visitor

Re: Histogram visual doesn't display negative values

@v-yuezhe-msft

Do you have any suggestion how to deal with it? If possible I'd rather not use bar charts instead of histograms.

Moderator v-yuezhe-msft
Moderator

Re: Histogram visual doesn't display negative values

@gabriela,

You can submit a feature request in Power BI ideas forum, or send a email to Power BI Custom Visuals Support (pbicvsupport@microsoft.com) about how to add negative values in this chart.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gabriela Regular Visitor
Regular Visitor

Re: Histogram visual doesn't display negative values

Hi Lydia,

 

thanks for your suggestions.

 

Thanks,

Gabriela

th0ger Frequent Visitor
Frequent Visitor

Re: Histogram visual doesn't display negative values

This is a bug - negative values are shown incorrectly. Confirmed for Oct. and Nov. 2017 releases.

 

Has it been filed?

 

 

gabriela Regular Visitor
Regular Visitor

Re: Histogram visual doesn't display negative values

@th0ger,

from my conversation with the PowerBI helpdesk, it seems they plan to release an updated version of histogram visual in the middle of December. 

gabriela Regular Visitor
Regular Visitor

Re: Histogram visual doesn't display negative values

Hi all, just to confirm, MSFT solved the issue with negative values in the histogram visual in the latest update (December 2017).