Forum Discussion

Kjenmal's avatar
Kjenmal
Regular Visitor
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

As you said, when you use a SSAS Cube, you are restricted. You cannot change nothing with your end-user app (xls or PBI).

 

So, check the time format on your columns on the SSAS Cube. Is it HH:MM:SS correctly? Cause PBI take the format which is on the cube.

 

PS : time format is a hell....

  • Kjenmal's avatar
    Kjenmal
    Regular Visitor
    8 years ago

    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's avatar
      SiyaMac
      Icon for Advocate I rankAdvocate I
      8 years ago

      Hi 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