Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vk1982
New Member

Weeks in Year - Missing Data

Hey,

 

I'm showing a chart with X Axis of week number in year 1-52.

This is based on a table of events carrying an action date. I'm trying to see how many events were completed in each week. However if there is no event in a certain week the X Axis just misses out that week number....

In reality I want to see 1-52 and 0 next to that week number....

 

Any ideas would be appreciated... I am just starting out so finding my way around Power Bi..

 

Thanks

 

V

1 REPLY 1
Greg_Deckler
Super User
Super User

First, make sure your x-axis is set to "Continuous" and not "Categorical". Click your visualization, paintbrush on the left, x-axis it is the top attribute setting.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.