cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VizWiz Frequent Visitor
Frequent Visitor

Extra Bar Appearing in Stacked Column Chart

Hi,

 

I am trying to plot a chart with a column that only has 2 unique values but when I use it a stacked column or row chart, I get a 3rd bar appearing that has no values appearing.  The values are 0 and 1, but 0,1,1 appear when I plot it with nothing appearing in the middle 1. Data type is numeric so issue shouldnt be spaces around 1 throwing it off.


Does anyone know how to remedy this? I click on the dropdown in my data for that column and there are only 2 distinct values.

Thanks in advance,

Vizwiz 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Extra Bar Appearing in Stacked Column Chart

HI, @VizWiz 

I have test on my side, it works well.

Could you share your sample pbix file or some sample data with some screenshots?

There may be something wrong in other.

 

Best Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
VizWiz Frequent Visitor
Frequent Visitor

Re: Extra Bar Appearing in Stacked Column Chart

solution was to chage data type from number to text..

but as stated there were only 2 possible values for the numbers, 0 and 1..

 

thanks!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 266 members 2,941 guests
Please welcome our newest community members: