Forum Discussion
Chiclet Slicer
Hi team,
I had a model which has chiclet slicer for month names. As you can see below.
The way I sorted the month name correct is by putting column 'month' (a column that has month as whole numbers, ex 1 for jan, 2 for feb ...etc) as values. As you can see below.
This way i could sort by 'Month' column and ensure that months are showing up in correct order in the chicetslicer.
Suddeny something happened and i cannot put 'Month' in Values anymore. Has anyone seen this as to why this might be happening? and how to fix it?
Hi, Anonymous
You can do it by using sort by column function.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Hi, Anonymous Because this visual is not official, and the creator doesn't seem to set the use of values. So we need to use other ways.😊
3 Replies
- v-janeyg-msftCommunity Support
Hi, Anonymous
You can do it by using sort by column function.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
- AnonymousNot applicable
this was easy. I still think it is a bigger issue as to why i cannot add a column to the values field, but for now the solution worked. Thanks a lot
- v-janeyg-msftCommunity Support
Hi, Anonymous Because this visual is not official, and the creator doesn't seem to set the use of values. So we need to use other ways.😊