Forum Discussion

marinaadriana_'s avatar
marinaadriana_
Frequent Visitor
5 years ago

Hide repeating values in Matrix

I have a quite large Matrix containing 9 attributes for rows, 2 columns and 3 attributes in the value box. 

I need to hide 2 of 3 values. One of the values needs to be shown only as a total and the other one is for sorting (i've tried to do a sort by column but it doesnt work). 

 

What i've tried to do is to hide all the values by turning off word wrap and just slide it until it is not visable. Whenever the data gets refreshed, all of the hidden values re-appear! I have also hidden an attribute that is set on the rows and this works fine, but as long as it is on values it just appears after every refresh. Auto Alignment is turned off.

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi marinaadriana_ ,

     

    This is possible to do using a hierarchy in a disconnected table for the columns part however without a sample of data and expected result is difficult to give you the correct answer.

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.