Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |