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.
Hi!
I am trying to get the hour for each day where I have the max ammount of, say, occurrences.
So, I have a row for each occurrence, containing the day, time and type of the occurrence.
I want to show it in a bar graphic with lines "the hour with the max occurrences" for each type.
For example, I have this table:
DAY - HOUR
1 - 8
1 - 8
1 - 9
2 - 8
2 - 10
2 - 10
I want to show in my graph, for each day the amount of occurrences in bars, and a line of the hour where I had the most occurrences.
Day 1 would be the hour 8, while the day 2 would be the hour 10.
I tried with maxx, summarize, calculate, but with no success.
How can I do it?
Solved! Go to Solution.
@parry2k I think you misunderstood my problem. I don't want the maximum hour, I want the hour (this can be any hour of the day) with the maximum occurrences. I guess that I will solve this only with a measure, or a couple of them.
Edit1: Maybe if there was an aggregation of mode (statistics) it would work. Speaking of mode, I will try this.
Edit2: Edit1 didn't work 😞
Edit3: this works great 😄
@binamac when you drop HOUR on value section bar chart, just change aggregation to MAX instead of SUM
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k I think you misunderstood my problem. I don't want the maximum hour, I want the hour (this can be any hour of the day) with the maximum occurrences. I guess that I will solve this only with a measure, or a couple of them.
Edit1: Maybe if there was an aggregation of mode (statistics) it would work. Speaking of mode, I will try this.
Edit2: Edit1 didn't work 😞
Edit3: this works great 😄
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 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |