Hi All,
I use the attached bar chart to visualize the measures by Weeks. These weeks is based on the fiscal calendar I updated as a direct table to my app. So the question, is it possible to view or differentiate the weeks dimension by showing which week falls under which month? lets say- WK18-WK21 are the weeks that fall under the Month of May.
Is it possible for two dimensions exist at a same time in this bar chart? So that user can not only see the Weekly summary but also know at which month do these weeks belong to?
Dimension- Rolling 13 weeks-=if(Date>= WeekStart(Today()-91) and Date<= WeekStart(Today()-7) , [Week Number])
Alternate Dimension- Month-=if(Date>= WeekStart(Today()-365) and Date<= WeekStart(Today()-7) , [Month])
