Forum Discussion
PowerBI Visualization
Hi all,
When I create a visualization I get this blank column in my chart. Can you please help me with this?
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.
4 Replies
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
Hi,
Share the download link of the PBI file.
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.
