Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Members,
I would require your help in solving a visualization query
The query is I would like to view null values in X axis. For certain visuals, I am able to visualize null values but for other visuals, I am not able to see them. Can you please let me know how to resolve this?
Example: Expectation that I want is
What I am seeing:
Solved! Go to Solution.
@Jo5hua22
Select the chart then right-click on the Axis field and select Show Item with no data option
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Make sure it is a date hierarchy so that dates will be continuous.If there is no continuous date in your data model, please create a calendar table and create a relationship with the fact table.
Calendar = CALENDAR(MIN('TABLE'[DATE]),MAX('TABLE'[DATE]))
@Jo5hua22
Select the chart then right-click on the Axis field and select Show Item with no data option
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
In my scenario I have age buckets and when I apply a filter to my BSA groups for example i only get to see the buckets that have values. I would like to see all buckets still even if value is null or just empty. Is there a shortcut for that as well? The solution above is turned on but does not quite do the trick. My buckets are on the X-axis.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
3 |