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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Date column showing time

Hi,

I am creating a paginate report against a power BI dataset.

I have a date column, that in power query is specified as date format.

In the Power BI desktop it is specified as a date column.

However, as soon as I use that column in a parameter field in the paginated report it is showing time 

 

Redback971_0-1650519357848.png

The underlying DAX is  EVALUATE SUMMARIZECOLUMNS('EOM report'[inspection_date])

 

in DAX studio it also shows time

Redback971_1-1650519409582.png

I only want to display the date, how can i make the time not show?

 

thanks

4 REPLIES 4
PC2790
Community Champion
Community Champion

Have you tried to change the Format of the Date clumn to only show date from your Power BI desktop?

 

PC2790_0-1650520497276.png

 

Anonymous
Not applicable

yes

Redback971_0-1650520915135.png

 

PC2790
Community Champion
Community Champion

Try chaning it in properties pane if that works.

Refer Solved: Format datatime in paginated report - Microsoft Power BI Community

Anonymous
Not applicable

The issue is with the parameter field.  I don't see any option to format a parameter in the parameter properties.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.