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

0
votes

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

1
powerbipowerbi-desktoppowerbi-embeddedpowerbi-datasourcepowerbi-custom-visuals

1 Answers

1
votes

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.