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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
iBusinessBI
Kudo Collector
Kudo Collector

Sort by Column sends error for rows with BLANK() values / Spaces

I want my P&L Report to contain blank rows.

When I inport this table to the model and try to sort the "PL Title" column by the "Order" column, it shows error for duplicate values in the "PL Title". I understand, they are blank rows with different order. I tried to enter different spaces, also I tried to use 

non-printable spaces

Text.Repeat(Character.FromNumber(0032),[Index])

Still no luck.

Please help

 

iBusinessBI_0-1682067420743.png

iBusinessBI_1-1682067466450.png

 

 

1 ACCEPTED SOLUTION
iBusinessBI
Kudo Collector
Kudo Collector

Ok, I've found a solution.
I've repeated non-breaking spaces different times for different rows and it works.

Text.Repeat("#(00A0)",[Index])

View solution in original post

1 REPLY 1
iBusinessBI
Kudo Collector
Kudo Collector

Ok, I've found a solution.
I've repeated non-breaking spaces different times for different rows and it works.

Text.Repeat("#(00A0)",[Index])

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.