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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
janitor048
Helper I
Helper I

Mixing Marker and Non-Marker Lines in Line Chart

I want to do something that is perfectly easy to do in Excel but I can't figure out how to achieve the same in Power Bi.

Suppose I have the following data:

IndexDataLowerUpper
1214
2425
3736
4547
5758

I would like to create a diagram where the "Data" column is represented as markers while the columns "Lower" and "Upper" are just dashed lines without markers. In Excel this looks like this

MixedChart.png

 

How can I get the same in Power Bi?

 
1 ACCEPTED SOLUTION
janitor048
Helper I
Helper I

Oh, nevermind. I found it. There is a small option "Adapt Series" ("Serie Anpassen" in German, not fully sure about English version), once clicked it expands and I can select marker and line types individually. Well hidden...

View solution in original post

1 REPLY 1
janitor048
Helper I
Helper I

Oh, nevermind. I found it. There is a small option "Adapt Series" ("Serie Anpassen" in German, not fully sure about English version), once clicked it expands and I can select marker and line types individually. Well hidden...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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