Sort Column Chart based on column which is not included into visual

Question

Assume I have column chart with:&nbsp;1. Name: on Axis field.2. PaymentDayDiff on Value field.&nbsp;But I want to sort the columns chart based on another column call `Spend` which is not available on Sort dropdown (because `spend` is not included into `Axis` or `Value`)&nbsp;How can I do this?&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

In Desktop, you can go into your model, choose your column and set the "Sort By" column. 5th button from the left on the Modeling tab of the ribbon.

jdbuchanan71 · Answer

This topic came up first in my search so I though I would reply with an answer. If you add a measure to the tooltip of a visual, it is not displayed but you can sort by it. Thanks to GuyInACube for the video.

https://www.youtube.com/watch?v=1bp_e-ik7aA

cuongle · Answer

Thanks for your answer, but I am afraid that it does not work, the reason might be I did filter and select top n (use RANKX) for this column chart?

greg_deckler · Answer

Hmm, are you getting any error or are you setting the Sort By column and the visual is not honoring it?

I have run into an issue using FIRSTDATE on a custom column and then trying to use it as a Sort By column and received an error that I was not allowed to do that. That's the only time I have had this not work.

greggyb · Answer

In general, it's suggested that the sort-by column have a 1:1 relationship with the sorted column, e.g. MonthNumber sorts MonthName, each with 12 distinct values.&nbsp;Strictly, sort-by:sorted must be 1:1 or 1:N. In the 1:N case, the sorted column will have an order associated with sort-by, but will be sorted by its own value within the groups defined by sort-by.E.g. Sorting MonthName by QuarterNumber will give youFebruaryJanuaryMarchAprilJuneMayAugustJulySeptemberDecemberNovemberOctober&nbsp;This is the display in a table. All of Q1's months are grouped together, but since they are tied on their sort-by number, the tie is broken by sorting on MonthName's own value within that quarter.&nbsp;N:1 sort-by:sorted will throw an error.

Forum Discussion

Sort Column Chart based on column which is not included into visual

6 Replies

Related content

How to include multiple columns in Activator

New Column

include extra column - target

Grouping rows by Column and then updating Column

Dynamics 365 connector not including column RegardingObjectTypeCode