Matrix visual - Measure to be shown only in total's part of visual

[PavelR]

Hey guys,

I have been struggling with setting up my Matrix visual. What I want to do is to have 3 measures in my Matrix. However, the first two (called DEL and REJ) should be shown normally in a grid section together with totals, but the Monthly Limit measure (which shows Limits for last month) I want to have only in the total's section. Or just standing most on the right side let's say.

For better understanding see the picture below:

Do you have some idea on how to implement it?

Thanks in advance.

Pavel

[AlB]

Hi @PavelR 

A workaround would be:

1. Select the column you want to hide.

2. In the visualization menu, go to Format--> Column headers and set both Auto-size column width and Word wrap to Off

3. In the visual, reduce the width of the column until it disappears completely. This way it will be still there, but completely hidden 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[PavelR · Accepted solution]

Hi @AlB ,

thanks for your reply and tip, however, this is not a much convenient workaround. I would have to reduce column width with every new month and even when I do it the formating is quite bad = lines in the grid do not align, and every row is huge in terms of height due to the reduced columns with values.

I will go on with my workaround - report page tooltips.

Thanks.

Pavel

[edhans]

You can turn them off @PavelR - just go into the settings for the matrix, Subtotals, and turn on Per Column setting, then disable the subtotals you don't want.

You can see in my mocked up data the subtotals fo the YearMonth are off, but for the grand total it stays visible.

[mahoneypat]

You can make those columns return blank, but you can't remove them completely.  To make them blank, you can use

NewMeasure = IF(HASONEVALUE(Table[Month]), BLANK(), [Your Expression])

Regards,

Pat

[PavelR]

Hi @mahoneypat ,

thanks for your suggestion. I have already tried that, but it is unfortunately not the result that I want 😕

Another workaround has come up my mind and it is actually to use the Report page tooltip. I do not think that there would be anything better...

[karthikplsql198]

Hi Pavel,

Will Monthly_limit appear for each row or only one column for total report ?