Skip to main content
Microsoft Idea

Power BI

Needs Votes

DAX function to deactivate column presence in a visual

Vote (1) Share
A Power BI User's profile image

A Power BI User on 12 Feb 2021 13:50:33

Example: I've got a VAR% measure to calculate ratio between multiple years in a matrix column. Formula comparing current year with previous one. The first year doesn't have a previous one so I'm prompting blank, the problem is there's no way to remove that column from the first year.
It could be generally useful if we could conditionally deactivate the field presence in every visual with a dax function, like we've never included it in the visual.

Thanks