Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

remove date from time - Map

Hello everyone    I tried looking up how to sort out my problem but I couldn't find the answer so I'm asking here.    I have added the time to show up when someone is looking up on one event on t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi AlexisOlson  , 

     

    I have tried to do what you've advised me , so I defined the measure and followed your guide : 

     

     

     

     

    I can see that it still adds the extra date for no reason.  

     

    Sorry to be a pain , do you have other idea ? or I am doing it wrong ? 

     

     

    EDIT :  I've set its format as " text " , now it works, funny enough 

     

     

     

     

     

     

    All along I just knew it's going to be a simple fix , and I was just overthinking it 

     

     

     

    Edit 2 : 

     

    I've used the solution from here : https://community.powerbi.com/t5/Desktop/Concatenate-date-and-time-from-different-columns-in-one-column/m-p/1080188#M500292  

     

    and now I completely sorted out the problem .

     

    Thank you for your help 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you parry2k  and AlexisOlson    , I have tried both methods but still shows the same thing ,  for some reason it adds an non-existent date into my data.  

 

More photos added : 

 

Any suggestion is masivelly appreciated 

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

It doesn't look like you defined a measure as I suggested.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AlexisOlson  , 

     

    I have tried to do what you've advised me , so I defined the measure and followed your guide : 

     

     

     

     

    I can see that it still adds the extra date for no reason.  

     

    Sorry to be a pain , do you have other idea ? or I am doing it wrong ? 

     

     

    EDIT :  I've set its format as " text " , now it works, funny enough 

     

     

     

     

     

     

    All along I just knew it's going to be a simple fix , and I was just overthinking it 

     

     

     

    Edit 2 : 

     

    I've used the solution from here : https://community.powerbi.com/t5/Desktop/Concatenate-date-and-time-from-different-columns-in-one-column/m-p/1080188#M500292  

     

    and now I completely sorted out the problem .

     

    Thank you for your help