Sort by value

[wneiton]

Hi dear, 

I have three independent tables , that is, no relationships between them.
Each table has a column and I created a bar graph with them and I want to order it by value.

Thanks 

Wneiton

[Maddy99 · Accepted solution]

i hope this could help you visual.

old situation:

you have 4 separte measures

create a separte table for the legend. 

create a switch that combine your measure to the table. 

it would look like this.switch =

VAR Legend = SELECTEDVALUE(Table1[Column1])
RETURN 
SWITCH(TRUE();
    Legend = "Proposta2"; [Measure 2] ;
    Legend = "Proposta3"; [Measure 3];
    Legend = "Proposta4"; [Measure 4])

Now you have 1 measure that you can sort. 

choose you visual and i think you are done. 

change your setting in the colors if you want every measure to be a differnt colour. 

[v-chuncz-msft]

@wneiton,

You could also use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.

[Maddy99]

intresting question. 

for order value you must get 1 value. 

and ofcours you want 3 category. 

make a separte table with 3 rows. ever row has a text that repesent a category.

this column you can use in the legend. 

then make a measure with a swithc. 

when category = A then measure A

category = B then measure B.

i think this could help. 

[Maddy99 · Accepted solution]

i hope this could help you visual.

old situation:

you have 4 separte measures

create a separte table for the legend. 

create a switch that combine your measure to the table. 

it would look like this.switch =

VAR Legend = SELECTEDVALUE(Table1[Column1])
RETURN 
SWITCH(TRUE();
    Legend = "Proposta2"; [Measure 2] ;
    Legend = "Proposta3"; [Measure 3];
    Legend = "Proposta4"; [Measure 4])

Now you have 1 measure that you can sort. 

choose you visual and i think you are done. 

change your setting in the colors if you want every measure to be a differnt colour. 

[wneiton · Accepted solution]

Yes @Maddy99

Thanks for help, I've slightly changed a dax formula.

switch = SWITCH(Teste[Column1];"proposta1";[Media_Impacto1];"proposta2";[Media_Impacto2];"proposta3";[Media_Impacto3])

Teste = Table Name 

Media_Impacto = my measure from different tables (no relationships tables)

[Maddy99]

Yes that works to. 

i am happy that i could help. 

[wneiton]

@Maddy99 

@Greg_Deckler

I created a table with 3 rows. 

when I try to drag this table's column to the visualization, it's not possible! 

Sorry, but I didn't understand where and how to create this measure. 

[Greg_Deckler]

What @Maddy99 is talking about is the Disconnected Table Trick. Here is an article that discusses it:

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

[Greg_Deckler]

I don't believe that you can do that dynamically but you could do it manually by changing the order in the Value area.