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
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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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