Forum Discussion

harshagraj's avatar
harshagraj
Icon for Post Partisan rankPost Partisan
2 years ago

Day,Hour,Minutes and additional parameters

Hello all i have a below data. Items Value DateTime Single-Top 0.0340069 3/7/2024 2:28 Single-Top 0.0340069 3/7/2024 4:10 Single-Top 0.0340069 3/7/2024 8:07 Double Top 0.5 3...
Need Help
harshagraj's avatar
harshagraj
Icon for Post Partisan rankPost Partisan
2 years ago

Hi Dangar332 thanks a lot for your response but i need a parameter or a slicer to be used to represent that datetime in day,hour,minute etc like this. 

 

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, harshagraj 

 

in power bi desktop go to modelling tab > new parameter >select field> drag and drop column of day,minute,hour(which we make in power query) > and select create

 

here column name is different from you 

 

field parameter interface look like below

 

 

refer ARTICLE for more about Field parameter

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.