- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
How do we delete all other columns on the second visual (the on the right side) except Total column?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Ashish_Mathur Thanks for your feedback. I uploaded my Pbix file and modified the original content. Not sure what to do here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@jeroendekk Thanks for your feedback. I uploaded my Pbix file and modified the original content. Not sure what to do here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Best regards,
Jeroen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
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?
How does PowerBI control the layer (top or bottom) of multiple Visuals?
I have updated the file with the latest on here.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Best regards,
Jeroen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
07-11-2024 08:35 AM | |||
03-28-2024 10:50 AM | |||
01-13-2024 03:18 AM | |||
10-10-2023 06:40 AM | |||
02-19-2024 12:19 PM |
User | Count |
---|---|
95 | |
69 | |
44 | |
38 | |
30 |
User | Count |
---|---|
157 | |
101 | |
60 | |
42 | |
40 |