Displaying value on card monday, tuesday, wedesneday, thursday, and friday,saturday sunday together

[benjaminhoang]

Displaying value on card monday, tuesday, wedesneday, thursday, seperately and friday,saturday sunday together

[v-danhe-msft]

Hi @benjaminhoang,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[benjaminhoang]

Hey Daniel,

Here is my issue I hope it make sense. I have a card that shows work load done for the previous for each work day. When monday work day is shown I want it to show friday, saturday and sunday.

[v-danhe-msft]

Hi @benjaminhoang,

Could you please post me some data structure and your desired result or share the pbix if possible?

Regards,

Daniel He

[v-danhe-msft]

Hi @benjaminhoang,

Based on my test, you can refer to below steps:

1.I have entered some sample data.

2.Create a calculated column.

WeekName = FORMAT('Table'[Date],"dddd")

3.Create a Multi-Row card visual and add the [WeekName] field. Now you could see the week name in the card together.

You can also download the PBIX file to have a view.

 https://www.dropbox.com/s/brjrt7sym0606ej/Displaying%20value%20on%20card%20monday%2C%20tuesday%2C%20...

Regards,

Daniel He

[Greg_Deckler]

No real idea what you are trying to do here. You can use WEEKDAY to get the week day and then theoretically group them based on that, but I don't really understand what you are trying to accomplish.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490