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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
crln-blue
Post Patron
Post Patron

Looking for equivalent of Line-Bar combo in Excel to PowerBI

Hello!

 

I'm new to PowerBI (currently exploring) and I'm looking for possible replacement to the chart below:

crln-blue_0-1596437494852.png

It is made in excel where the line chart pertains to the 2019 data and the bars for the 2020 data. There are only 3 data columns used: a measure, a category (food type, corresponds to the colors of both the line and bars) and a date data.

 

I believe this is a bad way of representing data because it is quite confusing to the readers so I'm looking for another way to interpret it. There is no clustered stacked bars nor line-bar chart on PowerBI so my question is, is there another visual for this requirement? (I also tried hierarchy - I made a type & date hierarchy and placed it on the x-axis but it isn't right). 

 

Thanks in advance!

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi  @crln-blue 

To my knowledge, there is no visuals like this, but there is a workaround to get it.

Step1:

Create a measure for column

Bar measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2020))
Step2:
Create measure for different category

Line typeA = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019&&'Table'[category ]="A"))

Line typeB = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019&&'Table'[category ]="B"))

Line typeC = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019&&'Table'[category ]="C"))

 

Step3:

Now create a visual like this

1.JPG

and here is sample pbix file, please try it.

Regards,

Lin

Community Support Team _ Lin
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

4 REPLIES 4
v-lili6-msft
Community Support
Community Support

hi  @crln-blue 

To my knowledge, there is no visuals like this, but there is a workaround to get it.

Step1:

Create a measure for column

Bar measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2020))
Step2:
Create measure for different category

Line typeA = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019&&'Table'[category ]="A"))

Line typeB = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019&&'Table'[category ]="B"))

Line typeC = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year]=2019&&'Table'[category ]="C"))

 

Step3:

Now create a visual like this

1.JPG

and here is sample pbix file, please try it.

Regards,

Lin

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

HI @v-lili6-msft , thanks for the reply. I applied your solution and it solved my problem (although I admit there's a more better way to represent my data instead of line-chart combo). Will close this thread now. 

amitchandak
Super User
Super User

@crln-blue , refer if this can help

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak ! I also tried this but I still need my line chart to be a multiple line chart because I need to show the composition. Still, thanks for link!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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