You load a comma-separated file into Power BI Desktop. The column TransactionDate contains values such as 2023-02-25 14:34:00 and currently has the automatically detected data type of Text. You must enable a relative date slicer and keep the time component so users can later analyze intraday patterns. Which Power Query data type should you assign to the column before loading it into the model?
The relative date slicer and the built-in date hierarchy require the column to be a true date/time value, not plain text. Choosing Date/Time converts each string to a single datetime value that preserves the hour, minute, and second while remaining fully supported in the data model. Selecting Date would strip the time portion, Date/Time/Timezone would be converted to UTC and lose its explicit timezone metadata, and Text would prevent time-based filters or calculations. Therefore, Date/Time is the most appropriate choice.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a relative date slicer in Power BI?
Open an interactive chat with Bash
Why does the Date/Time data type support intraday analysis in Power BI?
Open an interactive chat with Bash
What happens to the timezone metadata with Date/Time/Timezone in Power BI?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .