How to freeze a column on a bar chart

[marcelammelo]

Hello, everybody!

I'd like to know if is possible to do a bar chart in Power BI like the image below.

I have a bar whose data is the cumulative of the year 2016 and then I have others bars whose data are the sum of each month of 2017.  Is there anyway to freeze the first bar (2016) on the bar chart?

Best regards,

Marcela. 

[v-qiuyu-msft · Accepted solution]

Hi @marcelammelo,

We need to create a summarized for year 2016 to return total value for all months in year 2016, then union this table with the table which has month values.

Assume the fact data likes below:

You can create another table with DAX:

Table = UNION(SUMMARIZE('Table1','Table1'[Year],"Amount",SUM('Table1'[Amount])),SUMMARIZE('Table1','Table1'[MonthName],"Amount",SUM('Table1'[Amount])))

Then create a column chart, drag Year column to Axis, Amount to Values. For details, you can download the attached pbix file to have a look.

Best Regards,
QiuyunYu

[marcelammelo]

Hello, @v-qiuyu-msft!

That's amazing! You're awesome!

Thanks a lot for the solution and example. You made it easier than I could imagine.

You really helped me.

Regards,

Marcela.