Forum Discussion

vk1982's avatar
vk1982
New Member
10 years ago

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

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    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.