How to Track Product Orders by Day of the Week (Monday-Sunday) in Power BI

[olwen_trg]

Hi Power BI Community,

I'm trying to create a report that shows how many products customers ordered on each day of the week (Monday to Sunday) over the course of a year. My goal is to see if there are any patterns in customer orders during the week.

Here’s what I’ve tried so far: I have a Date Table in my model, defined as:

And I created a measure for distinct orders per customer like this

I have SalesEnquiry[Completed Date] with format "*Wednesday, 14 March 2001 (Long Date)"

But the measure isn’t working as expected.

Any advice, tips, or DAX examples would be really helpful!

Thanks in advance!

[speedramps]

@olwen_trg Did this answer your question? If so please click [accept solution] and thank the helper or give feedback. Thank you.

[Thejeswar]

Hi @olwen_trg ,

From your DAX measure, I make an assumption that you are having a slicer for selecting the customer. In that case, a simple DAX formula like the one below should be enough to align your data in the matrix for the rows and columns specified in addition to the customer slicer. 

DISTINCTCOUNT(SalesEnquiry[Product])

But however it is always good to share some sample data that can be used with your logic for a much faster response from the community

[olwen_trg]

Thank you for your response, I have a measure:

but I don't know why, when I apply it to a matrix table with the Customer slicer, it doesn't work. I think the issue may be with my data format.

I'm so sorry, the dataset includes sensitive company info, so I’m unable to share it.

[Thejeswar]

Hi @olwen_trg ,
I can understand that the data is sensitive.

Is there a way that you can share with us some dummy data that can mimic the issue that you are facing. That will enable us to help you better in this issue

Regards,

[Ritaf1983]

Hi @olwen_trg 

Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to

How to provide sample data in the Power BI Forum

If possible, upload a simplified .pbix file using this guide:

 How to upload PBI in Community