Reply
JustinDoh1
Post Prodigy
Post Prodigy
Partially syndicated - Outbound

How to only show only Total column of Matrix visual

I am sharing my Pbix file here.

(Update: Later file is this (after deleting Columns - but still having a question)).

 

I have two Matrix visuals (one with yesterday's data (left side) and the other one for the Variance between data with day before yesterday's (right side)).

I am trying to display only the Total column from the right Matrix visual as shown below (orange box).

JustinDoh1_0-1637516879918.png

How do we delete all other columns on the second visual (the on the right side) except Total column?

 

Thanks.

 

 

 

 

9 REPLIES 9
v-jayw-msft
Community Support
Community Support

Syndicated - Outbound

Hi @JustinDoh1 ,

 

I don't think it's possible. If you put the measure to the first matrix, it will still display separated by [Player Name].

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
JustinDoh1
Post Prodigy
Post Prodigy

Syndicated - Outbound

@Ashish_Mathur Thanks for your feedback. I uploaded my Pbix file and modified the original content. Not sure what to do here.

Syndicated - Outbound

Hi,

Remove the Payers Name field from the Column well of the Visusualisation pane.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
jeroendekk
Resolver V
Resolver V

Syndicated - Outbound

Hi @JustinDoh1 
If there is one field in the value, like @Ashish_Mathur  said, remove the column field.

But maybe these are all different fields? Then you can solve it with a measure. Cannot give any detaisl without seeing more of the data.

Best regards,
Jeroen Dekker

 

Syndicated - Outbound

@jeroendekk Thanks for your feedback. I uploaded my Pbix file and modified the original content. Not sure what to do here.

Syndicated - Outbound

Dear @JustinDoh1 
I looked at the file. But it is like @Ashish_Mathur  said, remove the column value and you only get the total in a matrix.

Schermafbeelding 2021-11-21 192122.jpg

Best regards,
Jeroen

Syndicated - Outbound

@jeroendekk 

Thanks for your help and feedback!

I removed the Columns (and it is definitely better).

But, I still have the "Facility Name" showing.

Is it possible to remove that (it is Row) and only leaving with "Total" by chance?

JustinDoh1_0-1637542575243.png

JustinDoh1_1-1637542673673.png

If deleting the Row (Facility Name) is not possible (and leaving the Total), can I collapse two Matrix visual and having the Second visual going underneath the First one?

JustinDoh1_2-1637543148945.png

How does PowerBI control the layer (top or bottom) of multiple Visuals?

I have updated the file with the latest on here.

Thank you!

 

Syndicated - Outbound

Dear @JustinDoh1 
I looked at the file. But it is like @Ashish_Mathur  said, remove the column value and you only get the total in a matrix.

Schermafbeelding 2021-11-21 192122.jpg

Best regards,
Jeroen

Ashish_Mathur
Super User
Super User

Syndicated - Outbound

Hi,

Remove the field which you have dragged to the column labels.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)