Paginated Report column formatting

[aliahad]

Hello,

I have create a paginated report but number formatting is not working, I have changed the 'Text Box' property for the cell but my output is still displaying number with decimals:

Text Box Property boxOutput from the browser

I have refreshed my query multiple times but no luck.

Please advise.

Thanks,

Ali.

[aliahad]

Hi Jainesh,

The data type property was already showing the same, but I am still getting the extra decmals in the paginated report. I have saved the model, exit the Power BI and reopened it again but no luck.

Thanks,

Ali.

[jaineshp]

Hey @aliahad,

The number formatting in Text Box Properties only affects display formatting, not the underlying data type. Your data appears to be coming through as text/string values rather than numeric values.

• Go to your dataset properties
• Select the numeric fields (FLIGHT_GROSS_AMOUNT, FLIGHT_MILEAGE_MILES)
• Change the Data Type from "Text" to "Decimal" or "Float"
• Apply changes and refresh

The formatting settings you already configured in Text Box Properties are correct, but they only work when the underlying data is recognized as numeric rather than text.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer

[aliahad]

Hi Jainesh,

I already have done that earlier and refreshed the data mutiple times but no luck.

When I create a new visualization I can see the fomat properly but it is not show translating to the paginated report.

Thanks,

Ali.

[jaineshp]

Hey @aliahad,

• Go to Model view (the model icon on the left sidebar)
• Select their table and click on the FLIGHT_MILEAGE_MILES column
• In the Properties pane on the right, set:
  • Format: Number (or Currency if needed)
  • Decimal places: 0
  • Display units: None (or thousands/millions as needed)
• Save the report

This approach works at the data model level, so the formatting will automatically apply to ALL visuals using that column, regardless of visual type.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer