Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
Hello!
I'm new to PowerBI (currently exploring) and I'm looking for possible replacement to the chart below:
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!
Solved! Go to Solution.
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
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
and here is sample pbix file, please try it.
Regards,
Lin
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
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
and here is sample pbix file, please try it.
Regards,
Lin
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.
@crln-blue , refer if this can help
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
79 | |
64 | |
52 | |
48 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |