Forum Discussion
**Time Intelligence (Weekly)**
Hi, I want to display the data in the following way: - 1. Each day of the week gives me the summary for the week. Let's take Monday. I have a measure and Time Hierarchy (Year, Months, Day...
Hi Anonymous,
There are 2 common approaches that you could try:
- Use Group feature to create Bin with duration 7days (but the X-Axis will show Month-NoOfWeek - Jan-01, Jan-02,... instead of month-representative day of week)
right click in your date column and choose new groupchoose duration 7 days
- Add calculated column/custom column and using if/else and another DAX methods to geneate week name, and just use this column in chart, it will sum value automatically. (new calculated column)
Weeks Rep = 'Fact'[DateColumn]- WEEKDAY('Fact'[DateColumn]-2)please change this column format in Formatting tab of Modeling tab to what format you want
- Hi Anonymous,
For live connection, you need to prepare your dim Date/calendar from server side cause not able to create calculated column. And bin/group by feature does not support live connection so far, so you could support that idea by voting https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16910701-please-make-the-new-group-and-bin-features-work-ov
And https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c
Can we do the same on Live Connection?
tringuyenminh92
Memorable Member
Memorable MemberHi Anonymous,
For live connection, you need to prepare your dim Date/calendar from server side cause not able to create calculated column. And bin/group by feature does not support live connection so far, so you could support that idea by voting https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16910701-please-make-the-new-group-and-bin-features-work-ov
And https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c
For live connection, you need to prepare your dim Date/calendar from server side cause not able to create calculated column. And bin/group by feature does not support live connection so far, so you could support that idea by voting https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16910701-please-make-the-new-group-and-bin-features-work-ov
And https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c