Forum Discussion

Emmy66's avatar
Emmy66
Icon for Helper V rankHelper V
4 years ago

Last 6 weeks displayed as Week

Hi Everyone,

Attached is my pbix file which contains my data. The aim is to output the last six weeks in the other below (fig 1) instead of (fig 2) i.e showing week numbers. The visualisation will be the only visual to display last 6 weeks whilst others will only show the current week based on the selected date i.e. Friday of that week. This slicer will be based on DimDate[WeekEndFriday].

Any help on this will be appreciated.

Fig 1

 

Fig 2

https://drive.google.com/file/d/18JOrsIJnIMuQoRFC_8e0WRjDXixju0jA/view?usp=sharing 

4 Replies

    • Emmy66's avatar
      Emmy66
      Icon for Helper V rankHelper V
      4 years ago

      daXtreme Thanks for your prompt response. I've seen the video from Alberto Ferrari, my question is that instead of having week #s, can it be replaced with Week, Week-1, Week-2, Week-3, Week-4 etc.

      • daXtreme's avatar
        daXtreme
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Emmy66 

         

        Why could it be not replaced with anything else that is an ordered dimension? Alberto only shows you some pattern, even though he uses dates. But it's the pattern that's important, not the specific example.