Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
"I have case file data with interactions, and I am trying to create a histogram distribution of cases based on the number of interactions. I have grouped the number of interactions into bins. For example, the histogram shows 8 cases with 1 to 5 interactions and 4 cases with 10 to 15 interactions. I have already created a histogram using a line and clustered column chart, and now I am attempting to add a median line that represents the median of the interactions [1, 2, 15, 3, 2, 12, 5, 12, 10, 5, 6, 5, 4] is 5.5
Here is the chart I created using my real data
I would greatly appreciate any assistance.
Sample data
Case | Interactions | Date | Group |
45632 | 1 | 2/8/2023 | Sales |
68795 | 2 | 2/8/2023 | Campaign |
34522 | 15 | 2/8/2023 | Campaign |
34223 | 3 | 2/6/2023 | Campaign |
45233 | 2 | 2/6/2023 | Campaign |
44452 | 12 | 2/6/2023 | Marketing |
45323 | 5 | 2/3/2023 | Marketing |
43424 | 12 | 2/3/2023 | Marketing |
44532 | 10 | 2/3/2023 | Marketing |
55532 | 5 | 2/3/2023 | IT |
42345 | 6 | 2/4/2023 | IT |
22331 | 5 | 2/4/2024 | IT |
44214 | 4 | 2/4/2023 | IT |
Solved! Go to Solution.
@Sharma0815 , based on what I got
MedianX(Table, Table[Iteractions])
Use this in bar visual using analytics pane -> constant line - Fx option
or
Use this measure as line in combo visual
MedianX(allselected(Table), Table[Iteractions])
@Sharma0815 , based on what I got
MedianX(Table, Table[Iteractions])
Use this in bar visual using analytics pane -> constant line - Fx option
or
Use this measure as line in combo visual
MedianX(allselected(Table), Table[Iteractions])
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |