Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
goraem
Frequent Visitor

Day of week on visual instead of date

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. TIADOW.jpg

4 REPLIES 4
goraem
Frequent Visitor

Still having problems with this. Can anyone help?

Anonymous
Not applicable

Hi @goraem ,

 

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

 

Best Regards,

Jay

amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.