Forum Discussion

Kirikou's avatar
Kirikou
New Member
9 months ago
Solved

REPORT CREATION WHIN POWER BI

  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 o...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • CPCARDOSO's avatar
    CPCARDOSO
    8 months ago

    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!

Olufemi7's avatar
Olufemi7
Super User
8 months ago

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.