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 want to create a slicer for days that will have a default value ("Current Day") and numbers 1-31.
I've created a calculated column like the image below:
The problem with this code is I can't set [DD_] column data type to Whole Number because otherwise the type won't match with "Current Day" (Text data type), but if I change [DD_] column type to Text data type, the Day slicer won't sort nicely (example in image below):
If you have any idea, advice or better ways to approach this issue, I'm all ears! Thanks in advance for your help.
Solved! Go to Solution.
@NZ0090 ,
try to use Sort by column option, follow the below steps,
1. Select _CurrDay Slicer calculated column.
2. Then click Sort by column option from the Column tools menu.
3. Then sort the column using [DD_] column from the list. (this column data type should be in whole number)
Thanks,
Arul
@NZ0090 ,
try to use Sort by column option, follow the below steps,
1. Select _CurrDay Slicer calculated column.
2. Then click Sort by column option from the Column tools menu.
3. Then sort the column using [DD_] column from the list. (this column data type should be in whole number)
Thanks,
Arul
That works! Thanks for your help
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 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |