Show / Hide in Straight Table (Chart Exploration)

[prads_uk_2025]

Hey All,
Requirement: The column / Measure : Only([Mark Date]) should be displayed only when Asset Name and Asset IDs are selected from the Straight Table's chart exploration.
I tried Count([Asset Name]) > 0
, GetSelectedCount([Asset Name]) >= 1
nothing works

Need guidance here.

[MatheusC]

Hi,

From what I understand, the rule is that both fields must be selected for the correct field/measurement to appear?

That should be enough.

GetSelectedCount([Asset Name]) > 0
    and GetSelectedCount([Asset ID]) >0


- Regards, Matheus

[robert_mika]

only from this table or overall selections as @MatheusC  solution ?

[prads_uk_2025]

The solution is required for both the fields however, if it work for one it would work for other using AND/OR.
Count and GetselectedCount is not working in this case because it is just selection / deselection which itself in playing hide/seek.

[prads_uk_2025]

It should be field specific not table

[MatheusC · Accepted solution]

OK, you can test this approach. It's an alternative for this scenario, though not as practical.

GetObjectDimension() – will return the dimension.

if(match('[Asset Name]',GetObjectDimension(0),GetObjectDimension(1),GetObjectDimension(2),others...),1,0)

In other words, the expression will search for your dimension ( '[Asset Name]' ) if it's present among the columns in your report passed in index().

- Regards, Matheus

[prads_uk_2025 · Accepted solution]

Thank you so much for the logic.

=if(GetObjectDimension(4)='Asset Name',1,0)

This worked. I was using GetObjectField but above one seems easy peasy.

[MatheusC]

Good that it worked for your scenario, just be careful if the column is not static, it will be necessary to add the other indexes so that it does not lose dimension if the position changes.

Regards, Matheus

[prads_uk_2025]

Yes, I deduce that and so you solution works best however, the positions of those 2 dimensions are fixed so won't be an issue. Thank you once again for this amazing solution.