Show data data for latest month only

[NewbieJono]

I have a measure that calculates a total for each month and displays  a percentage. i have a fiscal year drop down filter on the page.

i would like to show a visual that shows the latest month based on fiscal year selected. so for the example below I would link to show a metric that outputs 90.53%.  but in 2024 it would show the latest month depending e.g in may it would show may.

hope that makes sense.

[v-yilong-msft · Accepted solution]

Hi @NewbieJono ,

Based on your problems, here are my answers.

I think you can let the Date become the slicer and it will show you the latest month.

Best Regards

Yilong Zhou

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

[Wilson_]

Hello NewbieJono,

Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂