新手求助：PowerBI能否实现类似Cognos的分组重复列表功能

Hey Tim, great question! Power BI absolutely can replicate that Cognos-style grouped list with repeated field entries—let me walk you through two straightforward ways to pull this off, since the default settings hide this functionality a bit.

Method 1: Tweak the Default Table Visual (Easiest Fix) #

This is the fastest way to get the exact repeated-field behavior you’re used to in Cognos:

• Drag all your required fields (both the grouping field and the related fields you want repeated) into the Values pane of a standard Table visual.
• Head to the Format tab (right-side panel) > Expand the Rows section > Toggle off Merge cells. This is the key! By default, Power BI merges identical grouping field values into a single cell—disabling this will make every row repeat the grouping field just like your Cognos list.
• Optional: To lock in grouping order, go to the Data tab, select your grouping field, and set a custom sort order (or just click the column header in the table to sort manually).

Method 2: Advanced Layout with Cards + Matrix #

If you prefer a more card-like layout (instead of a strict table), you can combine a Matrix and Card visual:

• Drag your grouping field into the Rows pane of a Matrix visual, then add a unique identifier for each list entry (like an ID field) directly below it in the Rows pane—this ensures every individual entry gets its own row in the matrix.
• Add a standard Card visual to your report canvas, then drag all the fields you want repeated (including the grouping field) into the Card’s Fields pane.
• Drag the Card visual into the Values cell of the Matrix. Now you’ll have a grouped list where each entry gets its own card, with all fields repeated exactly as you need.

Quick Pro Tips #

• Double-check your data model: Make sure you haven’t enabled Remove duplicates in your data load settings—you want every row of your source data to be represented in the report.
• Use conditional formatting on the grouping field (in the Table or Matrix) to add a background color for each group, making the list easier to scan (just like Cognos!)

内容的提问来源于stack exchange，提问作者Tim B