cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanessafvg Super Contributor
Super Contributor

Displaying Duration in visuals

I am using an MDX cube with a direct connection so i am unable to calculate duration.  Also using Power BI Report server if that makes any difference.   There is no duration data type as far as I know.  What is the best way to display this, using text is obviously not the ideal.

 

Just wondering what other people have been doing?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Displaying Duration in visuals

Yeah, unfortunately live connections to multidimensional MDX cubes do not support either DAX calculated columns or DAX calculated measures.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
Highlighted
Super User
Super User

Re: Displaying Duration in visuals

Yeah, it's an issue that I have been discussing for like two years now, the lack of a true duration data type or format display in DAX. Generally, you have to do things as discussed in this article:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

 

Obviously it ends up as text, which is the issue I've discussed with the product team at the last MVP conference. 

 

I also have a Quick Measure for doing the reverse:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

vanessafvg Super Contributor
Super Contributor

Re: Displaying Duration in visuals

@Greg_Deckler - thanks problem is im using a direct connection to a multi dimensional cube, any suggestions around that


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Super User
Super User

Re: Displaying Duration in visuals

Oh shoot, you did say that. Let me see if I can work up a way to do it with valid DAX functions in DirectQuery.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

vanessafvg Super Contributor
Super Contributor

Re: Displaying Duration in visuals

@Greg_Deckler sorry thats live query connection to SSAS MDX, so i have 0 control  of creating any measure too.. guess it will have to be text then?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Super User
Super User

Re: Displaying Duration in visuals

Yeah, unfortunately live connections to multidimensional MDX cubes do not support either DAX calculated columns or DAX calculated measures.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 277 members 3,362 guests
Please welcome our newest community members: