Hey there.
I have a vey simple situation. I have a dashboard where I need to put a Show if for some Detail columns. The main problem is that I need to change their visibility based on a column value from that same row, and that doesn´t seem possible.
Thanks!
To paraphrase, it sounds like you are saying that you want to show/hide columns in a Detail view that is part of a Dashboard. I is possible to do this but what we don’t know is if those columns need to have different visibility constraints in OTHER views also in the Dashboard. Let me explain.
In a Dashboard view, the CONTEXT() function does not have access to the “child” views of the Dashboard. However, you can specify the Dashboard view name itself. For example, if I have [Column A] and a “Test Details” view in a “Test Dashboard” view and I want to hide [Column A] when its values is < 500, then I can use a Show_If expression in [Column A] like this:
AND(CONTEXT("View") = "Test Dashboard", [Column A] < 500)
An issue occurs if I have other views showing [Column A] that don’t have the same visibility criteria.
Let’s says there is also “Test Table” view in “Test Dashboard” and I want it to ALWAYS show the value of [Column A] . There would be no way to implement this in the Dashboard view. I can only get CONTEXT about the Dashboard view and therefore cannot differentiate between the Detail view and the Table view to apply different show/hide logic.
On the other hand, if the intention is to hide the value everywhere in the Dashboard or show it everywhere, that can be done. Just use the Dashboard info in the CONTEXT function.