REPORT CREATION WHIN POWER BI

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!