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
Go to Solution.
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".)
MONTH ( 'Table1'[Date] )
2. Create a new measure.
CALCULATE ( SUM ( 'Table1'[Budget] ), ALLEXCEPT ( Table1, Table1[MonthNum] ) )
3. Create the visual with this new measure.
View solution in original post
@v-jiascu-msft Thank you, this is what I'm looking for.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.