Forum Discussion

gco's avatar
gco
Icon for Resolver II rankResolver II
7 years ago
Solved

Dates showing individually

can you please tell me what i am missing in my report?  I am trying to display the count of loans by entry date.  And the dates are showing individually.  I would like similar dates to combine.  Than...
Need Help
  • gco's avatar
    gco
    7 years ago

    Hi v-juanli-msft ,

     

    Thanks for replying.  I was actually able to fix my problem by changing the column type to 'date only' under edit queries.  For some reason, powerbi seem to still think that the column is datetime even though the format is already changed within the table, the format is already showing date and the column is already showing the date only value.

     

    This is the first time i have used the option 'date only'.  But it works :).

     

    Thanks again

    Glen

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi gco 

I can't reproduce your problem.

Could you paste some data here so i can test with it?

 

Best Regards
Maggie

 

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

  • gco's avatar
    gco
    Icon for Resolver II rankResolver II
    7 years ago

    Hi v-juanli-msft ,

     

    Thanks for replying.  I was actually able to fix my problem by changing the column type to 'date only' under edit queries.  For some reason, powerbi seem to still think that the column is datetime even though the format is already changed within the table, the format is already showing date and the column is already showing the date only value.

     

    This is the first time i have used the option 'date only'.  But it works :).

     

    Thanks again

    Glen