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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.