Power View - add support for non-numeric measures - by Darren Gosbell

Status : 


Sign in
to vote
ID 785964 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 4/30/2013 6:18:35 PM
Access Restriction Public


Currently Power View only supports numeric measures. Any measures that do not return a numeric data type are not available in the metadata pane. Adding support for non-numeric measures such as dates and strings would open up a whole raft of possibilitiies such as reporting on maximum or minimum dates for events. 
Sign in to post a comment.
Posted by Matt [MSFT] on 11/13/2014 at 10:18 AM
Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information.
Matt Jones
SQL Server Tiger Team
Posted by GregGalloway on 9/3/2013 at 3:46 PM
It seems like with variant measure support being added for DAXMD, this shouldn't be very difficult to add to Power View on top of Power Pivot or Tabular models.

Supporting text measures is important. Please prioritize.
Posted by Dan English on 5/1/2013 at 4:01 AM
Refer to the examples here for a date and string related measure https://connect.microsoft.com/SQLServer/feedback/details/784965/tabular-dax-measure-not-available-in-power-view-field-list#details