Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a Power BI dataset with many date columns. Here the Data type is set for "Date":
However when I build a PivotTable in Excel from this dataset in Excel it does not group into year/months but only shows each date:
How can I make it group to year/month in Excel?
Can anyone help?
try right click any date on the PivotTable, say 11/01/2017, do you have the Group option?
Unfortunately no
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |