Forum Discussion

mlilkas's avatar
mlilkas
Frequent Visitor
10 years ago
Solved

Leading Zero

Hello,   I am trying to set up some store numbers in Power BI so we can view information by store specifically. When I enter the store numbers, PowerBI will list items by leading number instead of ...
Need Help
  • asocorro's avatar
    asocorro
    10 years ago

    If your source data has leading zeros, then you need to solve this when you import the data (assuming you are not connecting directly to the data source), by making sure you format the column as text in the query editor.  Otherwise, you will need to create a calculated column that pads the store IDs with the correct number of leading zeros.

SJ's avatar
SJ
Helper I
7 years ago

Hi Maryann,

 

Tried a similar piece and have no issues but not sure what you are doing wrong.

The formula looks to be missing [] and the location it is pulling data from but not sure.

 

What you could try to make them unique is an "&" statement.

 

column 1 &" - "&max(Seq)

 

column 1 = column containing 12864 and 128641

 

This should work unless the error is in your: max(seq).

 

Hope this makes sense.

SJ

 

 

Maryann's avatar
Maryann
Helper I
7 years ago

Thanks SJ , This looks like a good fix .