Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Based on current week selection in Slicer Previous 6 weeks data display under line/bar chart

I'm Having Year Slicer, In that i have data for Years e.g Slicer 1st data as below 2017 2016 and second slicer is for weeks for those years e.g having below data Slicer 2nd data as below 02-...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks Eric_Zhang i tried another Solution and that's works for me . Thanks for your reply and help.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

Could you share your approach and accept it as solution to close this thread? People who have the similar question can benenif from the solution. :) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hello Eric_Zhang

     

     

    Sorry for delay in reply Actully i was on leave for few days.

     

    Hi @Eric_Zhang My Solution works only when there is no any relationship between 2 tables. You can checked in below images i i have selected weeknumbers 12 and in line chart data display from week numbers 12 to week numbers 6. As this soution working Properly.  

     

     

     

    Working when there is no relation into two tables

     

     but when i have added Datekey into both tables and Datekey here is Index column which makes active relationship into both tables then above solution is not working. i want above scenario working when two tables or more than 2 tables having

    relationship between them. 

     

     As in your solution you have rank column. Guide me on this Approach

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi

       

      If possible please write dax here for below solution?