How to only show only Total column of Matrix visual

[JustinDoh1]

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.

[v-jayw-msft]

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

[JustinDoh1]

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

[Ashish_Mathur]

Hi,

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

[jeroendekk]

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

[JustinDoh1]

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

[jeroendekk]

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

[JustinDoh1]

@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?

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!

[jeroendekk]

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

[Ashish_Mathur]

Hi,

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