How to turn off aggregation/calculation of a numeric column tool tip in bar chart

[Merradoc]

In my dashboard, I have a numeric field called SortOrder with values associated with department names. The purpose is to be able to sort the department names in the same specific order each time in visuals. It works fine in a table visual when added as a field and selecting Don’t Summarize on the field once it's placed in the field well.

When using a bar chart, I add the sort order numeric field as a tool tip to be able to sort the data in the specific order without including it as a field within the table itself. Despite having selected Show Value as No Calculation, the tooltip always defaults to using a sum, rather than the actual values in the column. 

What do I need to do to get the tool tip to

use the actual values of the field then instead of a calculation?

Relationships

The columns SortOrder and DepartmentName are part of the same table (Table one). The visuals often use the field/column Department Name (Table one) with a measure from another table (Table two) called DistinctCount. There is one-to-one cardinality with cross-filter direction of both between the two tables.

Example of data

Table One
Dept Name	SortOrder
Dept A	1
Dept B	2
Dept C	3
Dept D	4
Dept E	5
Table Two
DistinctCount (measure)
12
27
16
52
199

[rsbin]

@Merradoc ,

You don't need to use the [Sort Order] in the Tooltip.

What you want to do, is select your [Dept Name] Column, then click on Column Tools in the Menu.

Click on the Sort by Column and then select [Sort Order]

Hope this helps.

Regards,

[Merradoc]

Thanks so much for your response! 

We're using Direct Query rather than Import, so I don't have Table View, which is where I think Column Tools would be present in the menu (please correct me if I'm wrong).

Any ideas for when Table View isn't available? 

[rsbin]

@Merradoc ,

You do not need Table View to access Column Tools.  It is available to you in your Report View:

 

Make sure you have your Column selected (from your Data pane - Yellow box on right)
Then you will have Column Tools available to you in the menu.  Red box at top.

Hope this helps.

[Merradoc]

@rsbin Thanks so much!

Unfortunately mine is greyed out - so I see where I should be able to select, but am unable to do so. 

[rsbin]

@Merradoc ,

From your Picture, it looks like you only have 1 Column in your Job Table.
In your original post, you said Table One has two columns, Dept Name and Sort Order.
There is no mention of a Table called "Job"
In order to be able to sort by another column, you need at least 2 columns in your table.

[Merradoc]

Thank you for your reply. 

In my example data above, I simplified the data by referring to Table One and Table Two. Table One's real name is Job. Only one field is showing in the image as I searched for the field (highlighted in yellow below).

Here’s an image when I’ve included the three columns in a chart and Column Tools are still greyed out. Notably, sorting by the field isn’t actually a problem with a table, as I can select “Don’t calculate”, however if the visual is a bar chart (which is my goal), that option doesn’t appear. 

I just came across this article with a similar question and the response states: The connection mode of this pbix file is Live connection. So the model is not stored in your pbix file, this is the reason why you can not change it. You can check the mode at the right bottom of this window.

My connection mode is Live connection as well, so I'm presuming I've exhausted my search trying to sort using the Column Tools. 

Anyways, just posting that in case someone comes across this post and has the same issue that I did. 

Thanks so much for your time. 

[rsbin · Accepted solution]

@Merradoc ,

Are you connecting Live to an SSAS Tabular Model by chance?

If so, there is should be a Sort By option within the Visual Studio model that will resolve your issue.

[Merradoc]

Thanks so much. That will be it. Have a great day!