Forum Discussion
Sort in a slicer
Ok, thanks everyone for your help.
I undestand better my issue.
I want to use just a attribute (a single column) from a table "Products" for a slicer, but I didn't create first a table for this attribute.
I think I should first create the table for the attribute with id and label as columns, and after it will be possible to use differents columns of the new table for the slicer.
B.
Community ChampionHello BertrandD ,
they created another column to use only for order.
You will still use you orig column but you need to sort it by the new column.
As you are saying, the Sort by Column is Gray and is disabled,
you can click any column then select your slicer column again and the sort by column is clickable now.
Hope this helps.
Mussaenda,
I'm sorry but I'm a newbie with Power BI.
:smileyfrustrated:
I didn't solve my problem despite your explanations...
Let's better describe my situation.
I have a dataset called Fiche-Produit-Type (see screenshot).
In this dataset, I created the columns :
"Code activité" (id1), "Lib activité" (label1), and "Activité" (composed by id1 and label1)
"Code Groupe" (id2), "Lib Groupe" (label2), and "Groupe" (concatenation of id2+label2)
And I use two slicers for my graphics :
A slicer to choose the "Activité", and a slicer to choose the "Groupe".
But for my slicer "2" ("Groupe"), I don't find the way to associate to it the column "Lib Groupe" (label2).
Even when I select the column Lib Groupe, with my slicer selected, and I click on "Sort by column", nothing happens :
The slicer is still sorted by "Groupe" and not by "Lib Groupe".
And if I click on the 3 little dots on the above-right of the slicer, I don't have any choice for the columns on which I could sort.
Thanks
- mussaenda
Hi BertrandD ,
As what ChrisMendoza said,
you can find the sort by column on the modelling tab. and then you can see there the choices.
I think this video will help you understand more.
Ok, thanks everyone for your help.
I undestand better my issue.
I want to use just a attribute (a single column) from a table "Products" for a slicer, but I didn't create first a table for this attribute.
I think I should first create the table for the attribute with id and label as columns, and after it will be possible to use differents columns of the new table for the slicer.
B.