Put columns next to each other while using a slicer

[poweruser55]

I have a slicer in my app that changes the graph based upon ID selected. My question is how do I get the value which are comments to the right and not under the ID number. Also, is there a way to remove the decimals? I was able to do this in a table view but can't find the setting with a slicer.

[rsbin]

@poweruser55,

I would create a new calculated column to concatenate your ID and Comment fields.

Slicer = [ID] & " " & [Comment]

You should be able to format your [ID] field to 0 decimal places using the Column Tools menu.

Hope this helps.

[poweruser55]

I just realized that this makes nothing show up in the graph pane when an ID is clicked. I know why this is happening but how can we get it to just pull the ID part and not the text. @rsbin 

[poweruser55]

I got the column separated but now the ID numbers aren't in numerical order. How can I get it to reorder ascending ID? @rsbin It is putting 12 after 1 because it is taking the 1 in front of 12 instead of the entire number.

[rsbin · Accepted solution]

@poweruser55,

Select your new column in the Fields list on the right hand side.  You will get the "Sort by Columns" in the menu.  You will select Sort by your original ID field.

[poweruser55]

The slicer no longer works, when I choose an ID the graph pane is blank @rsbin 

[rsbin]

@poweruser55,

Am somewhat tied up this afternoon, but please post a sample of your table (in table format that I can copy) as well as a screenshot of the visual you are using.  I will try to have a look at it when I can.

[poweruser55]

Can I add a column to an already published file? Wouldn't I need to use the query editor? @rsbin