topic Re: I cannot add data to the "Values" of a matrix table in Report Server

I cannot add data to the "Values" of a matrix table

Pnopoes — Thu, 01 Aug 2024 11:58:10 GMT

I have a very strange issue:

I cannot attribute a data to the "Values" part of my matrix. I can only add measures - So it will work if I create a measure such as

Measure = MAX('DATA SITCOM'[End User])

However, with a previous version of the same .pbix file, I DO NOT have the issue at all and I can add any data. Worst, if I create the matrix in the previous version of the file, and copy paste it in the new version, it works...

I have another issue is that I cannot choose "last" for filters like Top N. I am thinking it might be related.

The new version of the file was worked on by an intern, so I don't know if he changed a parameter or so.

Anyone ever encountered (& solved :)) this issue ?

Re: I cannot add data to the "Values" of a matrix table

aduguid — Thu, 01 Aug 2024 12:33:24 GMT

I'd check the file settings between the current and previous versions to see if any thing is different.

Re: I cannot add data to the "Values" of a matrix table

Pnopoes — Thu, 01 Aug 2024 12:41:16 GMT

Thanks - I looked at Options & Settings and both files have the same selected 😞

Re: I cannot add data to the "Values" of a matrix table

Anonymous — Fri, 02 Aug 2024 03:13:51 GMT

Thank you aduguid

Hi, Pnopoes

Since your new version of PBIX creates calculated groups, then it will not be possible to add other fields to the values of the matrix. For this reason I made a simple sample data:

We can add other fields to the VALUES of the matrix normally when I don't create a calculated group:

When I create a calculated group, I can't add fields to values, but I can add measures to values:

Since your original report did not have a calculation group, you copied this measure and it worked fine. This is a feature of the Calculation group and you can learn about it from the link below:

Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: I cannot add data to the "Values" of a matrix table

Pnopoes — Fri, 02 Aug 2024 06:42:10 GMT

Thank you very much Anonymous

It was indeed the problem - I guess my intern fiddled with Calculation group. There was none, but the property "Discourage Implicit measure" was turned on.

I include a screenshot of where it is as I struggled a bit to find it.