datepowerbilinechartx-axis
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.
- Whats the point of Locale in DateTimeFormatter?
- Get mySQL MONTH() to use leading zeros?
- What is this date format? 2011-08-12T20:17:46.384Z
- Iterating through a range of dates in Python
- How to subtract two java.sql.Date dates?
- How to add months to a date in JavaScript?
- Displaying the build date
- How to correctly join two tables that each have Start Date and Stop Date columns?
- Why does Date() and Calendar.current.startOfDay(for: Date()) produce different days?
- Converting Excel Date Serial Number to Date using Javascript
- Convert date to datetime in Python
- Format date as dd/MM/yyyy using pipes
- Converting Date to epoch milliseconds
- HIVE SQL script to set end date to 12-31 of current year
- Is there a way to count number of ISO weeks in a given year using Moment.js?
- How can I modify this script to select any folders dated in the last 12 months?
- Find first Monday of given month or last Monday of previous month
- Why is Date behaving quirkily in JSON.stringify replacer?
- Uncaught TypeError: Cannot read property 'split' of undefined
- Sort List of Tuples by Date element
- get last three month records from table
- set the end date based on start date in the html input field using js
- Convert an array of datetimes into a comma-separated string of hyphenated range expressions
- Convert ZonedDateTime to java.util.Date
- Get number of days for previous month
- How to convert to Date format like 'January 2024' in T-SQL?
- FIRST and LAST VALUE bringing conflicting row quantities in the same query. WHY?
- Month and Year picker in Material UI React
- SAS proc import imports date with dots at random place. How can I solve this problem?
- Get timestamp from old data file