Forum Discussion

Pnopoes's avatar
Pnopoes
New Member
2 years ago
Solved

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

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 ? 
matrix
values
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

     

     

     

     

    • Pnopoes's avatar
      Pnopoes
      New Member
      2 years ago

      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.

       

       

  • aduguid's avatar
    aduguid
    Icon for Memorable Member rankMemorable Member
    2 years ago

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

    • Pnopoes's avatar
      Pnopoes
      New Member
      2 years ago

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