Hide a column in matrix

[SwathiBadveli]

Hi All,

I have a requirement from user to hide a sub column because that column is repeated.

In the above snip sum of benchmark column it should display only one for 1M period and not for all the periods,I hide the column by turning off the text wrap for column headers like below

Is there any other way than this to hide a column because when I am giving for each header diferent colors like above snip its appearance not good so could you please provide any other way how to acheive my scenario.

[Ritaf1983]

Hi @SwathiBadveli 
Please refer to the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/hiding-columns-in-Matrix/m-p/544289

(second suggestion of @Pragati_Sharma  with the creating table and selectedvalue)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[SwathiBadveli]

Hi RItaf,

Thaks for solution, but for scenario its not working as expected because we are taking the columns from different tables.

[Ritaf1983]

Hi @SwathiBadveli 
I think that you still can create a table with wanted categories from both tables.

If you attach some dummy pix, I will try to create it

Anyway, there is no generic solution for this issue, so it can be or solution with creating a "third table" or with minimizing columns width like you did.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[SwathiBadveli]

Hi,
Assume this my sample data

and this is the new table I created 

and this is the measure created

MV =

switch (

    true(),

    SELECTEDVALUE('Table'[Column1]) = "1M" && SELECTEDVALUE('Table'[Column2]) = "MV",

CALCULATE(SUM(Sheet1[MV]),

Sheet1[Period]= "1M"),

  SELECTEDVALUE('Table'[Column1]) = "1M" && SELECTEDVALUE('Table'[Column2]) = "Benchmark",

CALCULATE(SUM(Sheet1[MV]),

Sheet1[Period]= "1M"),

SELECTEDVALUE('Table'[Column1]) = "3M" && SELECTEDVALUE('Table'[Column2]) = "MV",

CALCULATE(SUM(Sheet1[MV]),

Sheet1[Period]= "3M"),

SELECTEDVALUE('Table'[Column1]) = "6M" && SELECTEDVALUE('Table'[Column2]) = "MV",

CALCULATE(SUM(Sheet1[MV]),

Sheet1[Period]= "6M"),

SELECTEDVALUE('Table'[Column1]) = "1Y" && SELECTEDVALUE('Table'[Column2]) = "MV",

CALCULATE(SUM(Sheet1[MV]),

Sheet1[Period]= "1Y"),

SELECTEDVALUE('Table'[Column1]) = "3Y" && SELECTEDVALUE('Table'[Column2]) = "MV",

CALCULATE(SUM(Sheet1[MV]),

Sheet1[Period]= "3Y")

)

and created relation b/w period and column many to many bi-directional.

period for 1M not showing beacause for period IM it should display both MV and benchmark for remaining it should display only MV.

[Ritaf1983]

can you please save the PBIX on some drive and share the link?

[SwathiBadveli]

Hi,I dont have access to share the link,Hope you understand my requirement so please can you provide a sample file with my requirement if possible.