Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamatic calculation based on slicer

Hi,   I have been struggling with this question for a while. Here is what I was trying to accomplish: for a selected day, I will show the stats for that day and average stats for the same day of w...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

To achieve this, you need to build two slicers. For example, you have slicer1, slicer2, visual1 and visual2. You can disable interaction from slicer1 with slicer2 and visual2, and disable interaction from slicer2 with slicer1 and visual1.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, Jimmy.

 

Could you give me more details regarding how to use two slicers to filter out the current date in the second visual, and dynamatically select one year data to report on? Thanks,

 

Kathebrine

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your response, Jimmy.

       

      The post you refered to is interesting, for sure I will be using that in the near future.

       

      But my question is more basic than that. I am struggling with calculating stats for same day of week in the past year giving a date. For example, if Novmeber 14, 2019 is selected, I should present average counts for all the Thursday within one year before Novmeber 14, 2019.  Below is what I got so far, but it doesn't give me exactly what I want. Thanks,

       

      Avg Shift Offered Calls =
      CALCULATE(
          AVERAGEX( VALUES( 'SUMMARY'[DT_DMN_ID]), [Call Offered]),
          DATESBETWEEN('Date'[CALENDAR_DATE],
      NEXTDAY(DATEADD(LASTDATE('Date'[CALENDAR_DATE]),-1,YEAR)),
              LASTDATE('Date'[CALENDAR_DATE]))
      )
       
      Thanks,
       
      Katherine
      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Anonymous ,

         

        Generally, you need to create a week No. column to mark the week No. and 7 days in a week so that you can achieve the average count in a calculate expression.

         

        In addtion, if you can share some sample data and give the expected result, I can do further analysis.

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.