Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

Show data data for latest month only

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Wilson_'s avatar
    Wilson_
    Memorable Member
    2 years ago

    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. 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.