Forum Discussion
Displaying time measure from a multidimensional SSAS cube in PowerBI
I have a requirement to visualise average handling time as a "Card" visualisation in PowerBI. Visualising only seconds is not as useful as using it in a time format (HH:MM:SS) and so I want to conve...
Agreed :) I believe the format is ok in SSAS. Particuarly since it works fine when displayed in Excel.
Example MDX:
CREATE MEMBER CURRENTCUBE.[Measures].[ActualAverageHandlingTimeAccepted]
as iif ([Measures].[ActualTotalHandlingTimeAccepted] = 0
, null
, ([Measures].[ActualTotalHandlingTimeAccepted]/[Measures].[NoCallsAccepted])
),
FORMAT_STRING = "hh:mm:ss",
VISIBLE = 1,
ASSOCIATED_MEASURE_GROUP = 'CustomerContactAccepted';
SiyaMac
Advocate I
Advocate IHi kjenmal,
Did you ever come right with this issue,I also just came across it,My time format is correct on the Cube and it also shows perfect on Excel,Power BI just seems to be the issue.
Regards
Siya