Forum Discussion
BobtheBI_lder
3 years agoNew Member
Line Chart X-axis - More Labels on Continuous
Datetime Metric 12/31/2020 11:00:00 PM 100 12/31/2020 10:00:00 PM 200 12/31/2020 9:00:00 PM 300 12/31/2020 8:00:00 PM 200 12/31/2020 7:00:00 PM 150 12/31/2020 6:00:00 PM 2...
Anonymous
3 years agoNot applicable
Hi BobtheBI_lder ,
You can create a computed column and set it to Data type – Date Formate – yyyy-mm-dd in Column tools:
Date1 =
DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),DAY('Table'[Date]))
Set to Date in X-axis, not Date Hierarchy
The calculation and display are then aggregated based on specific dates
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly