Day of week on visual instead of date

[goraem]

Hi, i have a published data set connect to a excel workbook on a sharepoint site.
I have built a report connected to this. I want to change the visual to show count of DOW but just get dates. TIA

[goraem]

Still having problems with this. Can anyone help?

[v-jayw-msft]

Hi @goraem ,

Try using week as asix and using count of date as value.

Best Regards,

Jay

[amitchandak]

@goraem ,

You can create a new column

weekday = weekday([Date])

Weekday Name =  format([Date], "ddd")

In case you want to use second , mark the first column as the sort column

[goraem]

Thanks and sorry i am new to PBI. I dont have a table?