Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Clustered Column Chart Help

Hi All,

I am stuck on a request and hoping someone can help me find a solution, I have searched online without any luck.


I am using a clustered column chart to show actual vs budget by month (example below).

The page the chart sits in, contains a month slicer, which in order to show values for future budget months I have set not to interact with this slicer.


I have now had a request to only show values for actuals equal to or before the slicer value selected.  Therefore if someone selected February then the March actual bar would disappear but all months of budget can remain.


Is there anyway of doing such a thing?  If I make the month slicer interact with the visual, it would filter to only show the selected month.


Thanks in advance for any help available





Super User
Super User

@Badger43 , Create an independent date table and use that in slicer


new measure =
var _max = maxx(allselected(Date1),Date1[Date])
calculate( [Actual], filter('Table', 'Table'[Date] 'Table'[Date] <=_max))


if you have joined date table


new measure =
var _max = maxx(allselected(Date1),Date1[Date])
calculate( [Actual], filter('Date', 'Date'[Date] 'Date'[Date] <=_max))



Same way you can measure for target too


Thanks for your help.  I have a joined date table and this is also used to filter various other views.


If I try and use your second solution would I filter the clustered chart by the month or not?  Thanks.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors