PowerBI Visualization

[DeekshaTS]

Hi all,

When I create a visualization I get this blank column in my chart. Can you please help me with this?

[Anonymous · Accepted solution]

Hi, @DeekshaTS 

I see that there is a small blue column chart in the view behind you that almost looks like you're gone. It's not a blank column, it's just that the data in front of you is too large, resulting in a range that is too large on the Y axis, and your subsequent data is too small relative to this range, making the column chart not obvious.

Just like this:

Perhaps you can edit the range of the Y-axis in the format

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@DeekshaTS  Try out this and disable the "Show item with no data" feature.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[tharunkumarRTK]

@DeekshaTS 

There can be mutiple reasons why you experience blank values. 

1. Verify your data and see if you can find any blank values in the column which you added into x axis of the visual.
2. If the columns that you would have added into x axis and y axis are from different tables then makes sure for every foreign key column value in the fact table has a corresponding primary key value in your dimension table. Otherwise by default power bi will automatically add a hidden blank row in the dimension table.

You can put visual level filter to remove blank values. Just select the visual and expand filters panel in the right hand side and exapand the column that you have added to axis and remove blank value.

Measure level filters can also solve the problem.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun