How to show moth data in all weeks of particular month

[Prathap1]

Hi all,

I'm a newbie for power bi now facing a new issue. Expertise please assist me in this with better solution

I've data looks like below. need to create a clustered column chart using below data.

But the budget amount will be shown at 1st date or any one date of the month. But the budget amount need to show in all the week bar(Week1, Week2, Week3, Week4, Week5)

My output coming like below

Please assist me.

Thanks in advance

Regards,

Prathap S

[v-jiascu-msft · Accepted solution]

@Prathap1

Hi Prathap S,

We could use a new measure instead of [Budget].

1. Add a calculated column of Month. (If the column "ID" is unique and same in one month, we can use "ID".)

MonthNum =
MONTH ( 'Table1'[Date] )

2. Create a new measure.

MonthBudget =
CALCULATE ( SUM ( 'Table1'[Budget] ), ALLEXCEPT ( Table1, Table1[MonthNum] ) )

3. Create the visual with this new measure.

Best Regards!

Dale

[Prathap1]

@v-jiascu-msft 
Thank you, this is what I'm looking for. 

Regards,

Prathap S