Forum Discussion

Lakshmiramesh's avatar
Lakshmiramesh
Regular Visitor
2 years ago
Solved

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

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,...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Lakshmiramesh
Regular Visitor
2 years ago

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.