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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
apessanha
New Member

Problem creating a graph with accumulated columns

 

Hello, I'm new to the forum and would like help with a question related to column charts in Power Bi.

Today we have a report at the company that compares the current month with the previous month. However, the graph (excel) has two columns at the end of the graph, after "December", there are two columns with the accumulated 2023 and 2024.
In powerbi, I was able to make the graph, but with the X axis in "Year_month". If I enter the month and compare the years, it gives an error.

Can you help me?

Below is an image of what the graph should look like.Grafico Excel.gif

 

 

3 REPLIES 3
apessanha
New Member

Hello, lbendlin.
So the problem I have to work around is this: I have a calendar base and a complaints facts base.

From this facts base, we extract the demand and complaints, ok!
In my model, we have the measures "total complaint", "total demand", "performance index", "previous year index" and "previous year demand".
I need to compare the performance index of the current year against the previous year, projecting this in a column chart.
This graph needs to have after the month of December, the cumulative of the current year and the previous year.
Ex:. Jan, Feb, Mar.... ten, current year, the previous one.

Is it possible to create this look?

second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

lbendlin
Super User
Super User

What's the error message?

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors