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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
GuilhermeMatte
New Member

Line graph with different interpolation type for each Series

Hello  Guys!

 

I have a normal line graph from another power bi file that contains two different interpolation methods, one for each line.

(see below)

 

GuilhermeMatte_0-1713334239520.png

 

when I try doing the same, I can only change the line type for BOTH series at the same time, not individually.

 

GuilhermeMatte_1-1713334348405.png

 

Any idea how to replicate this first image?  I've tried reverse engineering the other graph to the best of my abilities, but with no luck. The Target needs to remain constant for the whole year, and the granularity is also the year itself, so I need a stepped line to do the trick here.

 

I have the first graph, so I know its possible, unless it is a deprecated feature on something else!

 

Cheers!

 

 

 

1 ACCEPTED SOLUTION
Rlandrith
New Member

I am part way through a project using multiple line charts with dashed steps, just like you have pictured above. It seems like there was a change to prevent setting the line type per data series as I was able to do it last week. I was able to force it to work by saving as a .pbip file and updating the report.json file with the highlighted text in the pictureScreenshot 2024-04-17 140203.png

View solution in original post

5 REPLIES 5
juan_pablo
Advocate III
Advocate III

I was able to do it a few weeks ago. It doesn't make sense that it's deprecated now; it must be a bug.

 

juan_pablo_0-1716858722021.png

 

srherz
New Member

Should this really be marked as "Solved" given that this was a workaround requiring the edit of the report json? This is a valid report writing concern and given the "soft" removal of this interpolation-by-series feature, I imagine a number of users just haven't realized yet that this change occured.

Tagging a community support team member on this:
@Anonymous: Is there a reason why this functionality of combining different interpolation types by series was removed/depreciated from Power BI?  Is this a bug or was this an intentional shift away from this beneficial feature - and is there another workaround besides modifying the report json?

WillDrotar
Advocate I
Advocate I

A couple months ago it let you apply settings to each series, with Interpolation type as one of those you could define. It's now greyed out in the series for some reason. 

Rlandrith
New Member

I am part way through a project using multiple line charts with dashed steps, just like you have pictured above. It seems like there was a change to prevent setting the line type per data series as I was able to do it last week. I was able to force it to work by saving as a .pbip file and updating the report.json file with the highlighted text in the pictureScreenshot 2024-04-17 140203.png

Hello mate!

 

Right on point! I did as you suggested, but whenever I changed the parameter it would change for both lines again, so I had to find the line-specific parameter and add another section of the highlighted code of your image. In the end, I was able to figure it out!

 

GuilhermeMatte_0-1713396241913.png

 

Thank you very much @Rlandrith !

Cheers!

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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