Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
JohanEriksson
Frequent Visitor

Datetime measure displays just the date part (no time)

We have a problem with datetime measure when Connect live to Analysis Services Multidimensional model.

In Power BI report only the date part is displayed, although correct datetime is displayed when connecting to cube via Excel pivot. There is no difference between different  Power BI visuals, so I guess the formatting that removes the time part is done when connecting to the cube.

 

Since we use Connect live to the multidimensional model there is no possibility to format any measures.

 

Anybody know any way to show complete datetime measure?

 

Thanks in advance!

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@JohanEriksson 

 

You may take a look at Configure Measure Properties.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@JohanEriksson 

 

You may take a look at Configure Measure Properties.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks! Measure property FormatString solves the problem!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.