Allow table columns in matrices values area.

[MarkB63]

Sometimes I need to include a column that is in a table (ie NOT a measure) into the values area of a matrix to show on the detail lines.   Currently we can only add measures here.  I have found using 'selected value' and 'has one value' functions to create a measure can be a workaround for this.  It would be cool if PBI allowed this to happen automatically if trying to add a table column to a matrix, as I have been having to implement this workaround often in the reports I am requried to build for my company.

If anyone has any better thoughts on this, would love to hear them!

[v-xiaoyan-msft]

Hi @MarkB63 ,

Yes, there are a few other workarounds you can consider for adding table columns to the values area of a matrix in Power BI:

1.You can use DAX to create Calculated tables in the data model that refer to the existing data. This can help overcome limitations and unblock the refresh of queries while still processing custom calculations.

2.You may set Excel Workbook as a Source.Retrieve the results into an Excel table output type and use this as a source of data in Power BI. This allows you to add custom calculations directly into the existing data model.

3.Power BI has introduced a feature that allows you to define new measures in the DAX query view. This can simplify the process of creating measures and adding them to your matrix visual.

4. Enable the "Personalize Visuals" option in Power BI Desktop. This allows users to interact with the visuals and add columns or measures to the matrix visual by selecting them twice, as the first click might not always register.

Hope it helps！

Best regards.
Community Support Team_Caitlyn

[MarkB63]

Thanks very much for your thoughts!

-Mark