Forum Discussion
Display Highest Value on Card using Filter
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
| Strength Training | 31/12/2022 | 0 |
| Yoga | 31/12/2022 | 0 |
| Elliptical | 31/12/2022 | 0 |
| Kayaking | 30/12/2022 | 1.74 |
| Strength Training | 29/12/2022 | 0 |
| Yoga | 29/12/2022 | 0 |
| Walking | 29/12/2022 | 4.21 |
| Strength Training | 28/12/2022 | 0 |
| Yoga | 28/12/2022 | 0 |
| Indoor Cycling | 28/12/2022 | 0 |
| Strength Training | 27/12/2022 | 0 |
| Yoga | 27/12/2022 | 0 |
| Walking | 27/12/2022 | 3.82 |
| Strength Training | 26/12/2022 | 0 |
| Yoga | 26/12/2022 | 0 |
| Elliptical | 26/12/2022 | 0 |
| Yoga | 24/12/2022 | 0 |
| Indoor Cycling | 24/12/2022 | 0 |
| Walking | 23/12/2022 | 5.29 |
| Yoga | 21/12/2022 | 0 |
| Walking | 21/12/2022 | 5.26 |
| Walking | 20/12/2022 | 5.06 |
| Yoga | 18/12/2022 | 0 |
| Indoor Cycling | 18/12/2022 | 0 |
| Pool Swimming | 17/12/2022 | 700 |
| Strength Training | 17/12/2022 | 0 |
| Yoga | 17/12/2022 | 0 |
| Walking | 17/12/2022 | 4.9 |
| Yoga | 11/12/2022 | 0 |
5 Replies
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.
All good- I worked out how to add filter to the visual. Thanks again for your help.
