Forum Discussion
Column Names in Slicer
Hello All,
I have few columns Student Name,Student Number,Student Code in my Dataset table.
Generally we get the values of column in Slicer , But I want this column names in slicer.
Can any one please help me how can I get it.
3 Replies
I must be missing something. Slicers can take text or numbers. Remove the number column and add the name column.
Anonymous
Not very clear about your requirement but if you need to use a slicer and assign a Data Column to it please follow this link:https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Hey, @sam_powerbi
According to your requirement, I guess you want to use a slicer to cut the column name, you can try despivot columns in the power query editor, you can follow my steps:
- Open the Power Query Editor, click "Ctrl" and select in all three columns and click despivot columns, like this:
- You can then get a table like this, click Apply and Close
- Create a table chart, place [Attribute] and [Value], create a slicer, place [Attribute], and you can get what you want, like this:
You can download my test pbix file here
Best regards
Qin Community Support _Robert Team
If this post helps,then consider Accepting it as the solution to help other members find it faster.
