Matrix Visualization :How to hide columns and same time text wrap

[Lakshmiramesh]

Hej,

I need to hide columns , with the condition like before 2024 means hide few columns, after or current year means shows few column in matrix Visualization .

When I just adjust the slider, it is ok, but text wrap gives problem again.

In below :test,testetestetstetstest columns should show only on Currentyear.(2024) and column 'testetestetstetstest' 

[Anonymous · Accepted solution]

Hi @Lakshmiramesh ,

Based on my testing, please try the following methods again:

1.Create the simple table.

2.Create the new measures to filter the hide columns.

Hide column = 
var _dat = SELECTEDVALUE('Table test'[Date])
var pro_ = SELECTEDVALUE('Table test'[Program])
var result = CALCULATE(SUM('Table test'[Cost]), ALLEXCEPT('Table test', 'Table test'[Date], 'Table test'[Program]))
RETURN
IF(_dat = "Current year 2024" && pro_ in {"Budget", "Forbrug", "test1"}, BLANK(), result)

3.Drag the measure into the matrix visual values.

4.The result is shown below.

Best Regards,

Wisdom Wu

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

[Lakshmiramesh]

Thanks for the Help.

But I am not using any slicer to select the value ,Just display the data in Matrix. 

First two values itseif as a column in a table need to show before 2024. Dragged the

From third values, need to show only in 'Current year' in Date column.

Also the names are long, need to do textwrap.

For quick solution withouit using Dax, i just adjust it manually to hide,which works well. But when I do the Textwrap. it becames bad looks.

Thanks in advance.