cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kest Frequent Visitor
Frequent Visitor

Dates not shown on x-axis

Hey guys

 

I just started out with Power BI so please be gentle.

 

I have a very simple data set with weekly dates.

 

dates yellow.png

 

Now I'd like to visualize that data. And when I do so, that's what I get:

 

not shown.png

 

Dates are set to "day". Obviously I don't want to see absolute numbers but the dates I put in. When I model the variable the data type is set to "date" (dd.MM.yyyy).

 

What do I have to show the dates in the original Excel sheet?

 

Thanks for your help in advance!

 

Kevin

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dates not shown on x-axis

@kest This might be a "Type" setting issue based on what you are saying...

Click on the visual, click the paintbrush (formatting) -> x-axis -> Type -> Select categorical instead of Continous

 

Either that, or check edit queries and make sure the data type in the "load" section is also date.

Near SE WI? Join our PUG Milwaukee Brew City PUG
1 REPLY 1
Super User
Super User

Re: Dates not shown on x-axis

@kest This might be a "Type" setting issue based on what you are saying...

Click on the visual, click the paintbrush (formatting) -> x-axis -> Type -> Select categorical instead of Continous

 

Either that, or check edit queries and make sure the data type in the "load" section is also date.

Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 76 members 1,187 guests
Please welcome our newest community members: