Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
Hi, @salman_ali
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, @salman_ali 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.😊
Hi, @salman_ali
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
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
Hi, @salman_ali 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.😊
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
66 | |
59 | |
49 | |
36 | |
35 |
User | Count |
---|---|
84 | |
70 | |
58 | |
45 | |
44 |