Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow more granular X-axis data points than labels with Date Hierarchy

Vote (13) Share
Power BI User's profile image

Power BI User on 01 Apr 2020 18:18:13

Line chart: X-Date Hierarchy, Y-Value will only display one aggregated data point per selected time granularity (e.g. Month). In order to display daily values, one has to expand all down to daily data on X-Axis, which renders too many labels (one per day) and hence is not practical.

This works as expected when X is Date (instead of Date Hierarchy).

We need the Date Hierarchy in order to compare data across years (Years in Legend) side by side on X, rather than continuous.

Please enable more granular X-Axis Date points than labels with Date Hierarchy

https://community.powerbi.com/t5/Desktop/Continuous-X-axis-with-monthly-labels-daily-data-categorised-by/m-p/999438#M474740