Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
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.
You are welcome.
Hi,
You may download my PBI file from here.
Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |