Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I would like the user to have the ability to turn a few reference lines on and off independently of each other.
Using field parameters and a few DAX measures set up I nearly have a working prototype, but the issue is that if I set my false condition in the DAX to BLANK() then only one of the reference lines disappers, the other resets itself to 0. If I set the false condition to "" then both lines will disappear, but the value is getting set to something 0 like as it turns off my logarithmic axis (which doesn't allow for negative or 0 values).
How can I get this to work?
Thank-you in advance.
Reference Lines = {
("LOD", NAMEOF('Limits'[LOD]), 0),
("LOQ", NAMEOF('Limits'[LOQ]), 1)
}
Thank-you for the suggestion. I am already using bookmarks to switch between linear and log views, but if I have to I will resort to additional bookmarks showing/hiding the reference lines too.
The only way I know of to let your users toggle visual settings is with bookmark buttons. You duplicate the visual for as many settings you need them to toggle, then show/hide them with the bookmarks to display one per button with each setting. It sounds like you kind of want this to dynamically happen with what's going on in your chart, though, which this wouldn't solve for... You could potentially write a measure for the line vs using the built-in constant lines though, and have it return blank with an if-statement under your specific conditions?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.