topic Re: Cumulative bar chart comparing months by year in DAX Commands and Tips

Cumulative bar chart comparing months by year

Anonymous — Tue, 03 May 2022 15:56:04 GMT

Hello

I'm doing a clustered column chart showing quotes sent in each calendar month for both 2021 and 2022. The chart is displaying the May 2022 value for future months where I have no data. I want to show all of 2021 but only 2022 up to the current month where I have data (May 2022).

Can anyone help me please?

Re: Cumulative bar chart comparing months by year

speedramps — Tue, 03 May 2022 17:06:20 GMT

Create a dax masure a but like this to return the value is the date <= today,

and return dull when the value is > today

Graphvalue =
IF(
MIN(Table[date]) <= [todaysdate],

SUM(Table[value]),

BLANK()
)

I have helped you now please help me with kudos.
I am a Power BI volunteer so please click the thumbs up if you like me trying to help you.
And click Accept As Solution if I have fixed your problem.
One problem per ticket please. If you need to expand or change your problem then please accept this solution and raise a new ticket. Many thanks 😀

Re: Cumulative bar chart comparing months by year

v-yalanwu-msft — Fri, 06 May 2022 03:52:10 GMT

Hi, Anonymous ;

As I said, but since it's summation, you can change it to:

value = IF ( MIN ( Table[date] ) <= TODAY (), CALCULATE ( SUM ( Table[value] ), FILTER ( ALL ( 'table' ), [date] <= MAX ( [date] ) ) ), BLANK () )

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

Re: Cumulative bar chart comparing months by year

v-yalanwu-msft — Wed, 11 May 2022 06:41:01 GMT

Hi, Anonymous ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.