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
Hello I am trying to create a line graph visual that includes a projection of program enrollment over time (enrollment numbers on y axis, time on x axis). The project has 10 different sites enrolling patients to participate. The maximum number of individuals that can be enrolled by site is 130. I have the graph and I have the projection but I want to add a new measure that will cap each site at 130 so I can get an accurate estimate on timeline to study completion (enrollment= 1300). The dataset I'm using was designed for another purpose so it is in a less than ideal format but I think it can accomplish what I need. Below is a sample of the data table
Table Name: Test Tab
| Site Name | Timepoint | Patient Enrolled (Cumulative) |
| Site 1 | January 2022 | 5 |
| Site 2 | January 2022 | 9 |
| Site 3 | January 2022 | 3 |
| Site 1 | February 2022 | 13 |
| Site 2 | February 2022 | 22 |
| Site 3 | February 2022 | 7 |
Solved! Go to Solution.
@Cfrance28 , Based on what I got,
You can have a measure
max enrollment= 130
Use that as line in visual or as constant line using analytics pane -> constant line -> fx
@Cfrance28 , Based on what I got,
You can have a measure
max enrollment= 130
Use that as line in visual or as constant line using analytics pane -> constant line -> fx
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 28 | |
| 19 | |
| 11 | |
| 10 |