cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Prathap1
Frequent Visitor

How to show moth data in all weeks of particular month

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.

 

budget.png

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)

Datascrrenshot.png

 

My output coming like below

op.png

 

Please assist me.

Thanks in advance

Regards,

Prathap S

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft
Microsoft

@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.How to show moth data in all weeks of particular month.jpg

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jiascu-msft
Microsoft
Microsoft

@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.How to show moth data in all weeks of particular month.jpg

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

Regards,

Prathap S

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.