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
umutkaya79
Helper I
Helper I

Area Chart or Stacked Area Stacked Chart ?

Hi there,

I am trying to create this chart below. Does anyone know if I should use an area chart or stacked area chart ?  I have hour values on the x-axis and 4 values on the y-axis.  Dark blue color background is the first y-axis value and the rest 3 lines are the other y-axis values. 

 

umutkaya79_0-1681507065591.png

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @umutkaya79 
The graph needs to be a combination of an area and a line.
This functionality cannot be fulfilled by the default graphs.
Market Place has a type graph that you can download (free)

Ritaf1983_0-1681528443155.png

 

For each type of line you need, you need to calculate the measure separately

Put some lines as a primary value and some as a secondary value

Ritaf1983_2-1681528800605.png

This way, you can format each line / area as needed

Ritaf1983_3-1681528887572.png

 

Link to download file  

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



View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @umutkaya79 
The graph needs to be a combination of an area and a line.
This functionality cannot be fulfilled by the default graphs.
Market Place has a type graph that you can download (free)

Ritaf1983_0-1681528443155.png

 

For each type of line you need, you need to calculate the measure separately

Put some lines as a primary value and some as a secondary value

Ritaf1983_2-1681528800605.png

This way, you can format each line / area as needed

Ritaf1983_3-1681528887572.png

 

Link to download file  

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



Thank you so much @Ritaf1983

I was glad to help 🙂

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.