Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to build a continuous X axis for custom columns based on dates.
But I cannot, it doesn't let me switch to continuous.
Now I did see this solution, but as you see I did create and connect a separate table for dates which covers all dates in data table. And still I cannot change it to continuous X axis.
My end goal is to build a line chart for daily trend with around 1-3 month time horizon.
Solved! Go to Solution.
@Anonymous - I think you would benefit from a Date Dimension table. Please see attached for an example and try the following:
Thank you for hint.
Probably this won't work well for me, as if I change it to date format it defeats the purpose of my formula to make day-month format and pull appropriate data.
The way Power BI behaves when you use dates it takes absolutely all data for required category ignoring actual dates. For example ,if you use month ; day axis it will take all data for month regardless the year and will not show day. This is exactly the reason I use custom columns.
@Anonymous - I think you would benefit from a Date Dimension table. Please see attached for an example and try the following:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |