Forum Discussion

Badger43's avatar
Badger43
Frequent Visitor
4 years ago

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 (ex...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

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

 


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

 

if you have joined date table

 


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

 

 

Same way you can measure for target too

 

  • Badger43's avatar
    Badger43
    Frequent Visitor
    4 years ago

    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.