See records is not an option when a measure is used for a matrix

[Anonymous]

Hi,

I have a matrix that I added a measure for a variance %. This seems to work, but once that measure is added onto the matrix, i loose the ability to "see records" when right clicking on one of the values (not a measure value). See below for pictures of an example.

Before MeasureAfter Measure

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I'd like to suggest you to take a look at official document. Actually, it is a known limitation of see records feature.

Use See Data and See Records in Power BI Desktop

See Records has the following limitations:

• You can't change the data in the See Records view and save it back to the report.
• You can't use See Records when your visual uses a calculated measure.
• You can't use See Records when you are connected to a live multidimensional (MD) model.

Maybe you can submit an idea for add support to use this feature on measures.

Regards,

Xiaoxin Sheng

[sparkymark75]

Being unable to use the "See records" feature on visulaizations with a measure means I have to cancel our evaluation of Power BI for now and revert back to using SSRS, which is a shame as I really enjoyed Power BI.