CODEWITHSUNDEEP
sql-serverpowerbidax
Serdia
Serdia

Reputation: 4418

Why do I see "Blank" or "0" value at the begging of Stacked Column Chart in Power BI Desktop

For some reason stacked column chart displays "Blank" value even though data behind doesn't have any Blank or '0'.

enter image description here

And my X-axis doesnt have "Type" where I can choose between continuous or categorical:

enter image description here

In a data behind I have 12 months, no blank or 0 : enter image description here

Upvotes: 0

Views: 3078

Answers (1)

Foxan Ng
Foxan Ng

Reputation: 7151

The (Blank) value can occur even though your underlying data set has no blank values. It is because when you have established relationship between tables, and there are other visuals or filters on the same report page, leading to a joining or filter which results in blank values.

It can be hard to pinpoint sometimes, so the easiest thing you can do is to filter it in the Visual level filters as follows:

filter

As for the X-axis continuous or categorical type setting, it is only available when the data type is numerics or date/time. The MonthShort column you're using is just text to Power BI and it has no idea in what way it should be continuously linked. You need to use the MonthNumber or a date column if you want to achieve so.

continuous

Upvotes: 2

Related Questions