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
Hi everyone,
I have the following table :
dataset
I want to create a line chart using :
- X axis : column "Milestone"
- Y axis : Measure "Total Yes/No" (cumulative sum of column "Yes/No")
- Legend : column "SerialNumber"
- Slicer : column "SerialNumber"
I want that my graph shows a vertical line for each milestone (M1, M2) for each SerialNumber.
I tried many solutions but nothing worked.
If I use the "X ais constant line" in the analytics pane, it works for one SerialNumber but if I select multiple values in the slicer (2 or more SerialNumbers), I don't get the result that I want.
Here is what I have now :
Actual result
And this is the expected result :
Expected result
I hope there is a way to make it work as expected.
Thank you.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |