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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ethanqt
New Member

Help with multiple graphs

My goal is to create a chart with multiple line graphs in them where all of them are stepped except one. Currently I am only able to interpolate the whole chart as either linear OR stepped. I was wondering if there is a solution to where I can have my graph show one linear line graph and then the rest stepped? 

ethanqt_1-1718638819097.png

 

This is what I currently have in Power Bi

ethanqt_2-1718638856901.png

This is my goal. As you can see the graph in blue is the only linear graph. In Power Bi that would be my East Over/Under. 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @ethanqt 

 

Unfortunately, there is no way to combine two types of lines on a single chart using Core Graphs.

You can try to generate the desired output using Python/R and embed the result into your Power BI report.

Here are some links to tutorials on how to embed Python/R charts in Power BI:
Using Python/R visuals:

Microsoft Docs:  https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals

Guy in a Cube:  https://www.youtube.com/watch?v=3_DOF_qjguA

 

Using custom visuals:

Microsoft Docs: https://learn.microsoft.com/en-us/power-bi/developer/visuals/develop-power-bi-visuals

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

 

 

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @ethanqt 

 

Unfortunately, there is no way to combine two types of lines on a single chart using Core Graphs.

You can try to generate the desired output using Python/R and embed the result into your Power BI report.

Here are some links to tutorials on how to embed Python/R charts in Power BI:
Using Python/R visuals:

Microsoft Docs:  https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals

Guy in a Cube:  https://www.youtube.com/watch?v=3_DOF_qjguA

 

Using custom visuals:

Microsoft Docs: https://learn.microsoft.com/en-us/power-bi/developer/visuals/develop-power-bi-visuals

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors