Matrix Show Total only for One Value

[Anonymous]

Hi Team,

I have added a Matrix like this:

I have added State in rows, Pay date in columns, Earliest order date and Amt in Values.
Now I want to show totals only for Amt, not the Earliest Order date in row total, Please let me know how can i Achieve that.

Thanks

[truptis]

Hi @Anonymous , there is a sticky tape solution for this:

considering it is a matrix visual, select the visual, then go to the Format option -> Field Formating->(Select your filed):

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

By this way, the values won't be seen/hidden.

@Anonymous  -> If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 

[Anonymous]

Hi @truptis ,

Thanks for your reply,

I am using Power BI June Version and they have completely changed the formatting options. Here is the Screenshot, as you can see there is no Fileld formatting option.

And I dont want complete column to disappear, i want only the totals to disappear.

[truptis · Accepted solution]

@Anonymous -> Click on specific column field there you can see that option

Please mark this as a solution and hit the thumbs up if it helps you. Thanks.

[Anonymous]

Yes @truptis,

I Got it now, thanks