locked
Formatting PQ output for report RRS feed

  • Question

  • Hi,

    Is it possible to format (center, bold, shading for header, etc) in Excel PQ?  

    Also, can the column locations be fixed like the preview?  Sometimes they seem to move if the data changes in one column?

    Thursday, October 6, 2016 1:58 PM

Answers

  • The PQ data for reporting has to land somewhere - either in an Excel Table, or the Data Model. At these endpoints, you do the formatting. If you're doing the formatting in Excel, ensure that the following options are checked in the Table Tools-->Design-->Properties dialog box:

    (1) Preserve cell formatting - this option is checked by default
    (2) Preserve column/sort/filter layout - this option is unchecked by default

    • Proposed as answer by Imke FeldmannMVP Thursday, October 6, 2016 9:32 PM
    • Marked as answer by Bruce Stirl Thursday, October 6, 2016 11:21 PM
    Thursday, October 6, 2016 3:29 PM

All replies

  • The PQ data for reporting has to land somewhere - either in an Excel Table, or the Data Model. At these endpoints, you do the formatting. If you're doing the formatting in Excel, ensure that the following options are checked in the Table Tools-->Design-->Properties dialog box:

    (1) Preserve cell formatting - this option is checked by default
    (2) Preserve column/sort/filter layout - this option is unchecked by default

    • Proposed as answer by Imke FeldmannMVP Thursday, October 6, 2016 9:32 PM
    • Marked as answer by Bruce Stirl Thursday, October 6, 2016 11:21 PM
    Thursday, October 6, 2016 3:29 PM
  • That's what I thought.  But it doesn't allow the PQ tool to do formatting.  So the user needs to go in and adjust vs. setting a format and allowing the data to drive the look for a report.

    Thanks!

    Thursday, October 6, 2016 5:27 PM