Hiding specific columns of a column group inside a Matrix

[JeanMartinL]

Here is a very contrived example to show what I'm trying to do.

Let's start with this very simple dataset:

I then have a bunch of measures like:

MinA = CALCULATE(MIN('Table'[Value]),'Table'[Type] = "A")

And the equivalent for MaxA, MinB, MaxB.

I also have 2 mesures that redirect to the appropriate sub mesure depending on the selected type

Min =

VAR S = SELECTEDVALUE('Table'[Type])

RETURN SWITCH(TRUE,

S = "A", [MinA],

S = "B", [MinB],

-1

)

(Of course I realize that in this exemple this is not necessary, but it might be needed in a more complexe model with more complicated filters than simply [Type])

This gives me the result I want:

So far so good. But now let's say I want an unbalanced second level and don't always want to see Min/Max for all types.

For example, I don't want to see Min for "B". 

I thought I could simply return BLANK() for types I don't want:

Min =

VAR S = SELECTEDVALUE('Table'[Type])

RETURN SWITCH(TRUE,

S = "A", [MinA],

S = "B", BLANK(),

-1

)

 But when doing this, the column still shows with a blank. (And no, I don't have "Show Items with no data" activated).

Adding a Filter on "Min is not blank" removes the whole B type instead of just the empty column.

I feel like I'm close to a solution but I can't quite get there.

The other approach I tried is to remove Word Wrap and try to manually hide the column but resizing it ... but that also seem to be inperfect since it always leaves some space and with conditionnal formating in place it makes some pretty ugly and unuititive results (See the out of place red box of the resized column in this screenshot).

As a side note, we are using Report Server. I don't believe the Matrix in the cloud edition reacts differently but I could be wrong.

Thanks!

[v-cgao-msft · Accepted solution]

Hi @JeanMartinL ,

If you want to hide Min Column only under B but display it under the others, you can't do this like you would in Excel.

One solution I can think of is to mask this area with a graphic of the same color.

The PBIX file is attached for reference.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[JeanMartinL]

This is certainly not the most graceful solution but it is a solution, one that I hadn't considered.

Thanks for the help!