Forum Discussion
Sort by value
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
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.
8 Replies
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.
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.
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/ba-p/279563
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.
I don't believe that you can do that dynamically but you could do it manually by changing the order in the Value area.
You could also use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.
