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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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:
@v-xiaoyan-msft: 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
Helper I
Helper 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.