Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, everyone,
I have created an access from Excel to my Power BI data set (get data fram Dataset).
The data also arrive in Excel and I can use the data model in a pivot. But now to my little challenge, the date fields do not arrive as a date, but as text in the pivot. This makes it very difficult to filter these columns.
In power BI they are created as date fields and work accordingly
Is there a way to define the fields as dates in Excel for the Pivot?
best regards
nick
Solved! Go to Solution.
Hi @Nick001 ,
Here are the steps you can follow:
1. Enter the Power query interface and select the date column.
2. Select the two columns, Right Click --Change Type - Using Locale.
3. Select in Data Type: Date and Set the Locale (in your case you can use English - United States).
If the result is not what you expected, can you share sample data and sample output in table format?
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Nick001 ,
Here are the steps you can follow:
1. Enter the Power query interface and select the date column.
2. Select the two columns, Right Click --Change Type - Using Locale.
3. Select in Data Type: Date and Set the Locale (in your case you can use English - United States).
If the result is not what you expected, can you share sample data and sample output in table format?
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
THX, that works great - sorry for the late answer
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |