cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v-sheset Frequent Visitor
Frequent Visitor

Need the data type to be same as Query Editor, but it changes in Data view

Hello,

 

I am bringing the data in from Kusto to Power BI, and made changes in my qery itself to provide the data in Hours instead of days.

 

I am able to see correct calculation in the query and the PBI Editor when I bring my data in, however in the data view it starts showing everything in decimal instead of duration. I attempted to go to modeling tabe and edit the type, however it does not allow me to change and reflects some odd decimal values. 

I have tried a lot of permutaions and combinations to fix this, however it doesnt seem to work. Can you help me here ? I want the data to look like the format in the query editor view. Thanks in advance AfterClose&ApplyDone.PNGAfterDataLoad.PNGAfterDataLoad.PNG

2 REPLIES 2
Community Support Team
Community Support Team

Re: Need the data type to be same as Query Editor, but it changes in Data view

Hi v-sheset,

 

Click Modeling and change data type and data format here:

Capture.PNG 

 

Or you can create a calculate column using format function, please refer to: https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax.

 

Regards,

Jimmy Tao

Highlighted
v-sheset Frequent Visitor
Frequent Visitor

Re: Need the data type to be same as Query Editor, but it changes in Data view

Thank you @v-yulgu-msft I tried doing the same thing but there is no change. It does no effect on the values.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 4,083 guests
Please welcome our newest community members: