Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Sort Null values in column based on another column

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.

5 REPLIES 5
Anonymous
Not applicable

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'

KanishkaRandunu_0-1622034401260.png

 

edhans
Super User
Super User

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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
amitchandak
Super User
Super User

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

Appreciate your Kudos.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.