Multiple column sorting

Question

mkishore@lumenore.comBeginner

Asked: February 5, 20262026-02-05T14:53:49+05:30 2026-02-05T14:53:49+05:30Self Service

I need to show a bar chart where the sorting needs to be based on 2 columns

and then by

If I add these 2 columns 1 below the other in the sort box, it is still sorting by Deal probability alone.

You must login to add an answer.

or use

lmchandrakar@lumenore.com · Answer 1 · 2026-02-05T18:16:42+05:30

You must combine both columns into a single numeric sort key.
1. If Deal Probability is text like:

Create a calculated measure mapping first:

example :

CASE when “Deal Probability”=’High’ then 3

when “Deal Probability”=’Medium’ then 2

when “Deal Probability”=’Low’ then 1

end

Name this calculated measure as “Deal_Probability_Value”

2. Now create another measure as “SortKey” with a formula

“Deal_Probability_Value” * 100000 + “CurrentMonthClosureProbability”

3. Now add SortKey is Sort section of the chart with Desc order selected

✔ Result: