Forum Discussion
Solved
Conditional hiding of columns
In my table visual, I want to hide columns with no data when a slicer is applied. For example, if I use a slicer to select United States, and there is no data in a particular column for the United St...
The solution didn't work for me, but I'm having a colleague take another look. I will touch base again next week.
Thank you. Would you perhaps have an example of what the created measure might look like? I appreciate your help.
Hi dreamhouse32,
Below is the measure.
Sales_Visible =
IF(
MAX('Raw Data'[Country]) = "United States" &&
SELECTEDVALUE('Raw Data'[Sales]) = "-",
BLANK(),
SELECTEDVALUE('Raw Data'[Sales])
)
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu