REPORT CREATION WHIN POWER BI

[Kirikou]

Hello everyone,

I’ve been challenged to create a report within Power BI base on Excel file data Input  -

I’m New on Power BI and I ‘m completely lost when I have to create my report after load of my excel file using task , create a report – I don’t know how to do , and it seems that when I choose some column ( Filter) it show me a message as “ Number of digit superior to 3 “ Which exclude from my report several data surch as the data below in screen  

Thank you in advance for your help and guidance!

[Olufemi7]

Hello @Kirikou,

That error happens because Power BI is treating your MSN column as Text and applying a string‑length filter (digit count), which excludes values with more than 3 digits.

Here’s how to fix it:

1. Go to Transform Data (Power Query Editor).

2. Select the MSN column → change the Data Type to Whole Number (or Text if you want it treated as an identifier).

3. Remove any filters based on digit length.

4. Click Close & Apply.

Now you can build your report normally for example, use a Table visual to show ICAO, Poste technique, and MSN, and add a Slicer to filter by aircraft model (737, A320, etc.).

This will display all your data without exclusions.

[Royel]

Hi @Kirikou,

The "Number of digits superior to 3" message suggests you may have accidentally applied a Top N filte. Its better to start with a blank report as suggested by @GeraldGEmerick 

However you need to focus on this to overcome the issue:

1. Click on your visual > Look at the Filters pane on the right
2. Check if there's a "Top N" filter 
3. Remove or modify that filter

If that doesn't work, re-import your Excel file:

• Home → Excel workbook → Select your file
• Before loading, click Transform Data to open Power Query
• Check your column data types are correct (right-click column header → Change Type)

Thanks 

[CPCARDOSO · Accepted solution]

Hi @Kirikou 

Why you’re seeing “Number of digit superior to 3”

This message usually appears when:

• You applied a filter or condition that limits values based on the number of digits.
• Or the column is being treated as text instead of numeric, and Power BI is interpreting the filter incorrectly.

Steps to Create Your Report After Loading Excel Data

1. Load the Excel file:

   • In Power BI Desktop, click Home -> Get Data -> Excel.
   • Select your file and choose the correct sheet or table.

2. Check Data Types:

   • Go to Modeling -> Data Type.
   • Ensure numeric columns are set to Whole Number or Decimal Number, not Text.
   • This prevents issues with filters like “number of digits.”

3. Build Your Report:

   • Go to the Report view (canvas with visuals).
   • Drag fields from the Fields pane onto the canvas.
   • Example:
     • Drag a numeric column into a Bar Chart.
     • Drag a category column into Axis.

4. Fix the Filter Issue:

   • If you see “Number of digit superior to 3,” check the Filter pane.
   • Remove any filter that limits by digit count.
   • Instead, apply filters based on value ranges (e.g., greater than 100).

Quick Tips for Beginners

• Use Visualizations pane to choose charts (Table, Bar, Pie).
• Use Filters pane to refine data without excluding valid values.
• If your Excel file has headers or merged cells, clean it first for better results.

I hope you done!

[v-tsaipranay]

Hi @Kirikou ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @Kirikou ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by @GeraldGEmerick  . If you still require support, please let us know, we are happy to assist you.

Thank you.

[Kirikou]

Thanks for your prompt response , really appreciate it - I will Test your solution 

Regards - Kirikou

[GeraldGEmerick]

@Kirikou Start in Power BI Desktop. Create a blank report. On the Home tab, choose Excel workbook in the ribbon. Import your Excel workbook. Start there and nothing should be filtered out in your data.