Adding column to a Matrix

[subu_das]

Hello,

I need help with adding measures like Variance, YTD and Budget to Power BI in Matrix Visual for Actuals and Budget.

When i add Actuals the month are appearing as columns and values as below

When i add Budget to the matrix visual it is splitted in January Month ( i understand matrix visual is like a pivot table in excel) but in excel you can add columns and hard code besides it. Visual which appears as below is not liked by client.

Why it is so difficult in Power BI to add a hardcode column like budget next to a matrix as compared to excel. 

Can anyone help on this?

[subu_das]

I have used to create 15 measures, but the thing here is YTD changes for every year as we are interested in only days where the vessel was in operation. Some Vessels are sold in 2022, others in 2023 and so on 2024. So no of days becomes less in a particular year.
I have created each year Daily Run Cost as YTD is different.

[v-jingzhan-msft]

@barritown 's idea is doable. Here is a similar thread for your reference. Solved: Re: To show change in sales from last month foreca... - Microsoft Fabric Community

For the YTD changes, can you provide some sample data to show what desired result you want to achieve? You may need to modify the measure for it. We can help to see if it's possible to make it dynamic. 

Best Regards,
Jing

[barritown]

Hi @subu_das,

One of the options is to create a table like the one below, sort optionName by sortOrder, put optionName to the Column field of your matrix and create a measure which works with this table to calculate a proper value.

sortOrder	optionName
1	January
2	February
3	March
4	April
5	May
6	June
7	July
8	August
9	September
10	October
11	November
12	December
13	YTD
14	Budget
15	Var

Another option is to create 15 separate measures and place them one by one in the proper order to the value field of your matrix or table visual (in matrix you'll neet to transpose columns in its settings).

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian