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, Days). Now, is it possible to have the data only displayed for Jan 2, Jan 9, Jan 16, Jan 23 and so on without manually choosing the those days in the filter? I mean every time the data is refreshed in the cube I should be able to see only the data for every monday automatically updated. (Assume gateway is setup and working fine)
So if I open the report in march, it should have the data for every monday starting Jan 2 without me choosing those days in the filter.
Is it possible?
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
4 Replies
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
Thanks a lot tringuyenminh92 !! I will try this and let you know my result