Forum Discussion

SV1980's avatar
SV1980
New Member
4 years ago

Stacked Column Chart - Only Display relevant Data

Hi,    I have a stacked column chart and a date slicer.    When I select a date range, I want my x-axis to only display the data (in this case employee names) for that date range.    In this ca...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SV1980 , In the your date table is joined with book date, it will filter it.

 

else you have to create a measure like

 

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Book Date] >=_min && 'Table'[Book Date] <=_max))

 

here book date is only having date value

new column , if needed

Book Date = datevalue([Book Datetime])