Tuesday, August 16, 2011 4:18 PM
It doesn't look it is possible to put anything except measures on scatter plot axis. It would be really helpful to be able to put date values on the scatter plot axis and then put dates in the play axis giving the user the ablity to watch a trend move through time.
Tuesday, August 16, 2011 6:09 PMOwner
I tried to reproduce the issue, but I think I'm missing something in the steps. It seems to work fine for me to put non-measures into the playaxis field well drop zone, such as string values, integers (which are not marked as measures in the model), or date values.
Robert Bruckner http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, August 17, 2011 2:54 AM
I'm sorry I was unclear...
I'm trying to put the date in the X Axis AND the play axis field. It is the axis box that won't work.
Wednesday, August 17, 2011 6:15 AM
The scatter chart groups by the Details field (it creates one circle or bubble for each distinct value of the Details field) and aggregates the values of the horizontal and vertical axis fields, so those are measure axes.
Program Manager, SQL Server Reporting Services