Forum Discussion
Sorting Date Slicer in Power BI
I have created a seperate date table and joined it with the main table to resolve the issue. Thanks for all your help.
Hi,
In my dataset there are multiple columns.
When I grouped by Event date, I got this data and my report went for a toss.
Hi writetofaiz,
Group "All Rows" by [Date] column, sort [Date] column and then add Index column is to let same dates with the same Index.
Click expand icon in red box and expand all columns you want, then remove columns you don't need and rename the column names. Then you will get the result you want.
For reference: Work with a List, Record, or Table structured column (Power Query)
You can download my sample above and get more details about expand steps.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have created a seperate date table and joined it with the main table to resolve the issue. Thanks for all your help.