cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoeM
Regular Visitor

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.

YOY.png

Best Regards,

Joe

1 REPLY 1
Stachu
Community Champion
Community Champion

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!



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

Ted's Dev Camp - October 6, 2022

Watch the playback of Session 26 with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors
Top Kudoed Authors