Column Chart based on Month filter

[manishbeniwal]

Hi Team,
I want the chart should show me the columns based on selected Monthly (Filter). If I select "Jan", Chart should show only Jan data and If I select "Mar" then Chart should show the columns for Jan, Feb & Mar (means Jan to Mar) in the same column chart. Please suggest. Regards Manish

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here - Flex a Pivot Table to show data for x months ended a certain user defined month.

Hope this helps.

[sokg]

Hi @manishbeniwal 

You have to create a new measure

NewMeasure =
Var LastVisDate = max(Calendar[Date])

RETURN

Calculate(
                [YourOriginalMeasure],

                Calendar[Date]>= LastVisDate 

)

Hopefully this is what you are looking for!