Petja Sjö on 12 Jan 2023 09:34:48
At the moment it is frustrating to try to plot anything with custom date formats. As an example to plot something on a year/week level it is impossible to have the axis to show a custom label (e.g. week/year, as in 01/2023) and have the axis to be continuous. If the axis can't be changed to continuous Power BI will not display all data in one view but adds a scrollball. One way to elude this is to use custom calendar table, hide axis and create a custom tooltip but this becomes ridiculously difficult - if not impossible when you want to have multiple categories in one line chart (i.e. adding legend). Other way to do this is using custom calendar table with week start date column and use that as a date on x axis. Here the axis will be continuous but the x value will not be usable (will show the start day of the week). One way is to add a custom column (e.g. week/year) and add that to the default tooltip but the default tooltip will alwyas show the x axis value also (the unusable first day of the week as date). The simplest way to add usability here, would be to add customizability to the auto tooltips so you could for example hide the x axis value from the tooltip.
So much information is displayed on a weekly level so you should seriously add more flexibility to plotting options.