Forum Discussion
Order dates in text format in slicer
Hello all
I wanted to set a default value in a slicer with date values. So far i managed to get the expected results, but the order in the slicer ist not really correct.
Thisn is probably because i had to change the format from Date to Text. Because of the "Gestern" entry its not possible to convert to date again, but is there a way to order the dates correct descanding?
I thougt of using a yyyymmdd text format for the dates and order it, in excel it works.
The next problem would be displaying it again in the correct format...
Hope someone is able to help
Kind regards
Hi Anonymous,
You could use the feature Sory by column in Power BI.
1. Assuming that you have the date column like below.
2. Then you should create another table table 2 with the date column with descanding and create the index column.( You could order the date with desc in excel first. )
3. Create the relationship betweent the two tables and select the date column in table 2 and click Sort by column index.
4. Then you could create the date slicer with the date coumn in table 2.
Best Regards,
Cherry
1 Reply
v-piga-msftResident Rockstar
Hi Anonymous,
You could use the feature Sory by column in Power BI.
1. Assuming that you have the date column like below.
2. Then you should create another table table 2 with the date column with descanding and create the index column.( You could order the date with desc in excel first. )
3. Create the relationship betweent the two tables and select the date column in table 2 and click Sort by column index.
4. Then you could create the date slicer with the date coumn in table 2.
Best Regards,
Cherry