Continuous data on line chart using weeks in Power BI
I am trying to make a single line chart by putting weeks on x-axis and revenue on y-axis. However when add week data on x-axis it is all messed up.
I don't have any option to choose from categorical and continuous. I also have an issue that x-axis is long and not formatted to fit. Check the image below.
Solution
Your Start of Week column needs be of Date data type.
Select this column then go to Column tools in the ribbon. At the top left, change Data type to Date.
- Display dates in Arabic
- how to get a formatted date as milliseconds?
- How to trigger inline script onload?
- Simple date format. Date parsing
- Add A Year To Today's Date
- In java, Date() method returns a value. but I am confused in that
- Javascript add days to a date
- java.text.ParseException: Unparseable date
- How to partition an oracle table by a date column?
- How to output the date without a colon
- Calculate the date yesterday in JavaScript
- Javascript coding: Input a specific date, Output the season
- SimpleDateFormat Parsing Time and Date wrong minutes and seconds
- Subtracting datetime objects with Python
- Calculate days of each month in a range date in Excel Formula
- get number of days in the CURRENT month using javascript
- Issue with parsing Date string
- PS: Add-Content Get-Date & concatenate variable
- Left Outer Join doesn't return all rows from my left table?
- php weeks between 2 dates
- Why does SimpleDateFormat.parse().getTime() return an incorrect (negative) value?
- Why does moment.startOf go back 1 hour?
- Android: How to get values from date and time picker
- Android date format using SimpleDate
- Android SimpleDateFormat problem
- I want to compare string date (dd.MM.yyyy) to current date?
- Excel VBA Type-mismatch Date & Range
- Format particular date with T character
- JS how to add hours and minutes to scheduled date
- How to convert Year and Day of Year to Date?