I just started out with Power BI so please be gentle.
I have a very simple data set with weekly dates.
Now I'd like to visualize that data. And when I do so, that's what I get:
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!
Go to Solution.
@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.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.