Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Still having problems with this. Can anyone help?
Hi @goraem ,
Try using week as asix and using count of date as value.
Best Regards,
Jay
@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
Thanks and sorry i am new to PBI. I dont have a table?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |