Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Wiwi
Frequent Visitor

Draw vertical lines in a line chart graph while selecting multiple values in slicer

Hi everyone,

 

I have the following table :

datasetdataset

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 resultActual result

And this is the expected result :

 

Expected resultExpected result

I hope there is a way to make it work as expected.

 

Thank you.

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors