I have a line chart with some constant Y-axis values. I filter the line chart to different categories and everything updates appropriately.
However not every category has a value tied to it, some are blank. In these situations, the constant line is showing at the 0% mark rather than being blank. Is there anyway to just hide it instead? or make it transparent?
75th = SELECTEDVALUE(tbl[National75th])
maybe you can try to create a measure
if (xxx=0, blank(), xxx)
then it will skip the 0 value.
maybe you can try to create a measure
if (xxx=0, blank(), xxx)
then it will skip the 0 value.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
