Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The users are asking to make a few columns hidden when a report is exported into Excel. Is it even possible?
Thanks
On column visibility, try something like: =IIF(Globals!RenderFormat.Name = "EXCELOPENXML", true, false)
That will remove columns in Excel export because the expression is whether to hide.
Ah, you want excel hidden, not tablix hidden. I know of no way to do that.