Forum Discussion
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 ...
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
Thanks for sharing, the steps are easy to understand.😁
Paul Zheng _ Community Support Team