Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

dynamic YoY measures

I need to create a visual that gives the YoY comparison of sales by month.  I have no problem with creating the sales measure.  However, the years to compare must be dynamic.  That is, when there is ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I think I solved my problem.  Step 1 is to create generic fiscal year label column in the data model (e.g., FY-0, FY-1, FY-2, etc.).  Step 2 is to set the Legend of my line chart to be my regular fiscal year label column (e.g., 21-22, 20-21, 19-20).  Step 3 is to place my generic fiscal year label column into the filter pane, and select the default state (e.g., FY-0, FY1, and FY-2, not all fiscal years).

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I think I solved my problem.  Step 1 is to create generic fiscal year label column in the data model (e.g., FY-0, FY-1, FY-2, etc.).  Step 2 is to set the Legend of my line chart to be my regular fiscal year label column (e.g., 21-22, 20-21, 19-20).  Step 3 is to place my generic fiscal year label column into the filter pane, and select the default state (e.g., FY-0, FY1, and FY-2, not all fiscal years).