Forum Discussion
Use Calendar for Time Intelligence on another Table with Multiple Dates
gemcityzach Yeah, doesn't work that way other than perhaps overlaying two visuals but that's a mess. Better to create a measure for the closed count of ids like this:
Closed Count Measure = VAR __Date = MAX('Date'[Date]) VAR __Table = FILTER( ALL('Table'), [Closed Date] = __Date ) VAR __Result = COUNTROWS( __Table ) RETURN __Result
gemcityzach Yeah, doesn't work that way other than perhaps overlaying two visuals but that's a mess. Better to create a measure for the closed count of ids like this:
Closed Count Measure =
VAR __Date = MAX('Date'[Date])
VAR __Table = FILTER( ALL('Table'), [Closed Date] = __Date )
VAR __Result = COUNTROWS( __Table )
RETURN
__Result
Hey Greg that worked pretty well for me to convert it to a stacked bar chart. But now none of my on-page slicers work. I'm guessing I need to figure out a way to keep the 'Group' filter?
Edit: I changed FILTER ( ALL ) to FILTER ( KEEPFILTERS ...) and that worked! 🙂 Do you know how I might get the X-Axis to show Month-Year instead of MMM-DD?
gemcityzach That's typically done in your formatting for the column.
Yeah I checked for that but it doesn't offer the ability to 'group' the data into months. There are just variations on MM-DD-YYYY. I used the SQIBI calendar template (DAX Date Template - SQLBI).
gemcityzach Also, you could have used ALLSELECTED instead of ALL