Forum Discussion

JoeM's avatar
JoeM
Regular Visitor
7 years ago

Filter Percent Measure by Time

Hello,

   I have a Year Over Year percent calculation which displayed below. I need to show the data employing the Radar chart by Microsoft. This chart would use the Country as the Category. It requires a different measure for each column (year) that is displayed. What would be the best approach to slicing the data such that it can be displayed in the chart.

Best Regards,

Joe

1 Reply

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    7 years ago

    I guess there is no other way around but creating th measures per year, not very ellegant but should work

    YoY 2018 = CALCULATE([YoY], YEAR(Calendar[Date]) = 2018)
    Did I answer your question? Mark my post as a solution!

    Proud to be a Datanaut!