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.
Hello everyone,
I'm creating a dashboard using a direct query from a sql server view.
Problem:
I have several columns (datetime) and PowerBI recognizes them as so but it doesn't show the icon as a "date field" and I can't create a hierarchy based on month and year for example.
Thanks for your feedback !
Solved! Go to Solution.
Hi @Anonymous ,
Regarding the cause of this problem, you can refer to this:
But you can create hierarchical dates manually.
First, creating [Year], [Quarter], [Month], [Day] calculated column. ( You need to use YEAR(), QUARTER(), MONTH(), DAY() function)
Second, select the three points to the right of the column.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Regarding the cause of this problem, you can refer to this:
But you can create hierarchical dates manually.
First, creating [Year], [Quarter], [Month], [Day] calculated column. ( You need to use YEAR(), QUARTER(), MONTH(), DAY() function)
Second, select the three points to the right of the column.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can bring your own time dimension, that would be better. Refer: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intell...
Try to manually with custom date like [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.
hope it helps.
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |