Weekday as x axis instead of dates in line chart

[Anonymous]

Hi everyone

Let say I have a table like this:

Date	Value
10/2/2019	1
10/2/2019	3
10/3/2019	4
10/4/2019	3
10/4/2019	2
10/4/2019	1
10/5/2019	5
10/5/2019	6
10/6/2019	4

I want to make a line chart that showing sum of value of every date, but instead of showing date at the x-axis, I want to show the day of the week like Monday, Tuesday, Wednesday, and so on.

I am using Power BI May 2019 edition, and SSAS as data source. Some features isn't available when I am using SSAS as source. Please help, thank you

[Anonymous · Accepted solution]

Hi @Anonymous  ,

Below steps will help:

> Go to Query Editor 
> Duplicate Date Column

> Make sure it is Date Format

> Right Click on Column > Transform > Day > Name of Day


> Close & Apply

> Create new Bar chart visual 
> Use new Date column as Axis 
> Use Value Column as Value (Should automatically be aggregated as SUM. IF not, right click on Value field)

>Done

Let me know is any issue

Cheers
Rob

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.