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.


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

Proud to be a Datanaut!


5 REPLIES 5
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

 


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.


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

Proud to be a Datanaut!


Highlighted
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.


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

Proud to be a Datanaut!


Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 111 members 1,651 guests
Please welcome our newest community members: