topic Sort Null values in column based on another column in DAX Commands and Tips

Sort Null values in column based on another column

Anonymous — Thu, 05 Nov 2020 12:03:51 GMT

How can you sort null values in one column based on another column?

Against each null value in column A, there is a different value in column B.

Re: Sort Null values in column based on another column

AntrikshSharma — Thu, 05 Nov 2020 12:46:21 GMT

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Sort Null values in column based on another column

amitchandak — Thu, 05 Nov 2020 12:55:59 GMT

You can not. Sort column and column need to 1-1 mapping of values

Re: Sort Null values in column based on another column

amitchandak — Fri, 06 Nov 2020 16:30:25 GMT

Anonymous , Do the above replies help? if you need more help make me @

Appreciate your Kudos.

Re: Sort Null values in column based on another column

edhans — Fri, 06 Nov 2020 17:47:14 GMT

Can you explain what you are trying to do Anonymous ?

If all of the values in Column A are null, what good would sorting them by column B do? Just Sort column B. Everything in A is null so there is no right/wrong order.

Please post some data and expected results so we can assist.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

Re: Sort Null values in column based on another column

Anonymous — Wed, 26 May 2021 13:07:50 GMT

You can select the coulm A from values. and then select sort by and select the column B. In my Case I sorted column 'KPI Value" by column 'Sort KPI'