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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AAyaanmayank
New Member

How to add Line in clustered columns graph

Hi Everyone i am new to Power BI and trying to add display a parameter in Line along with other four parameters in Column i can do that in excel every easily by following this screen shot however not able to find any option on Power BI.Untitled.png

 

 

6 REPLIES 6
vk_pbi
Resolver II
Resolver II

Hi @AAyaanmayank 

You can customize it by using clusterd chart with line, there you can add seperate measure for line to show

vk_pbi_0-1684768804602.png

 

I have alreday tried this but Instead of giving to comletion number as Line it is showing all the number is line.  

Can you able to provide some more details like your data model, and what measures you are using.. for line chart, it would be helpful to provide output sample.. you can paste it from Excel chart images

Same data set from Power BI AND Excel

 

Untitled.png

In excel, you are taking this completed line in secondary axis, did you enabled the secodary axis option in your chart

vk_pbi_0-1684772090176.png

 

Yes It is enabled

 Untitled.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.