Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.