Forum Discussion
Matrix Show Total only for One Value
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
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.
4 Replies
- truptis
Community Champion
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.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
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.