cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amitkumar93
Helper III
Helper III

Matrix Show Total only for One Value

Hi Team,

I have added a Matrix like this:

amitkumar93_0-1656322883848.png

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

1 ACCEPTED SOLUTION

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

truptis_0-1656334719585.png

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

View solution in original post

4 REPLIES 4
truptis
Super User
Super User

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):

truptis_0-1656328004303.png

 

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:

truptis_1-1656328004094.png

 

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.

amitkumar93_0-1656333858563.png


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

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

truptis_0-1656334719585.png

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

Yes @truptis,

I Got it now, thanks 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors