Sorting second table based onclicked record in

[Anonymous]

Hello,

I have two tables.
I created relationship between these two tables.
If I click on record in my first table, in second table I see corectly records they responding to relationship between tables.

But I want sorting secord table by value from Column4, when I click on any record in table one.
For example I click on 5th record in table1 - and in column4 is value "RED"
Then in table2 results are sorting by "RED" in f.e column15 .

Is it possible

[v-xiaotang · Accepted solution]

Hi @Anonymous 

That is not possible. There are 2 ways to sort in PowerBI Desktop,

(1) Change how a chart is sorted in a Power BI report:

Change how a chart is sorted in a report - Power BI | Microsoft Docs

(2) Sort one column by another column in Power BI Desktop:

Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs

You can go to the link mentioned by amitchandak and submit your idea, then others can vote for it.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt that is possible. Please log an idea -https://ideas.powerbi.com/ideas/