Search code examples
powerbipowerbi-desktoppowerbi-embeddedpowerbi-datasourcepowerbi-custom-visuals

In Power BI X-axis label, how to show only week starting day instead of all date series?

Without grouping date values we need to customize x-axis label values week starting day. One more condition is we need to show all the value points in a week.

Right now my chart is

enter image description here

And what we need is

enter image description here

Solution

  • Just add the following calculated column in the query editor Edit Queries > Add Column > Custom Column:

    enter image description here

    Drag and drop the custom column into your visual and you are done. Don´t forget to change the type of the column to date format.