Forum Discussion
Column Chart based on Month filter
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
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.
2 Replies
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!
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.
