Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
"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 |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |