Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity 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

    • Anonymous's avatar
      Anonymous
      Not 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-msft's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity 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.😊