I would like to display highest value, filtered by category (Activity Type) to only show Walking (Activity Type) and display as Distance & Month. Therefore card value would change depending on which Month I walked the highest number of Distance. Eg: Expected Result: January 94
I've tried to create a measure but unsure how to add Filter to only display Activity Type Walking
Activity Type Date Distance
Solved! Go to Solution.
Hi @Ashish_Mathur Thanks for your assistance.
1) Max distance travelled in any month - Correct and working as expected
2) Period of Max Distance Travelled is showing December which is the highest before applying filter to show only Walking. How can I add filter to Measure to only show walking?
Any ideas where i may be going wrong?
You are welcome. Unless i see your file, I cannot comment. Share the download link fo the PBI file and show the expected result. Ensure that in the slicer, you select Walking.
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!