Join 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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
"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])
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 20 | |
| 12 | |
| 11 |