Forum Discussion

thaobui123's avatar
thaobui123
Regular Visitor
6 months ago
Solved

Download in CSV format does not match the format shown in Power BI Matrix visual

Hi Everyone, I am using a Matrix visual in Power BI with a layout similar to the screenshot below.   In the Matrix, I have multiple measures and I turned on “Show value in row groups rather ...
  • cengizhanarslan's avatar
    6 months ago

    When you export to CSV, Power BI exports the underlying data values, not the formatted values shown in the visual. CSV is a plain text format, so things like currency symbols, thousand separators, percentages, or display units (K/M/B) are not preserved.

    If you need the exported file to match what users see in the report, consider these options:

    • Export to Excel instead of CSV, which preserves formatting more reliably.

    • Create a formatted measure or column using FORMAT() if the formatted value itself must be exported.

    • For full control over export layout and formatting, consider using a Paginated Report, which is designed for pixel-perfect exports (CSV, Excel, PDF, etc.).