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
Go to Solution.
@amitkumar93 -> 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.
View solution in original post
Hi @amitkumar93 , 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.@amitkumar93 -> 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.
Yes @truptis,I Got it now, thanks
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.