Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hy everyone,
I built a visual with a CLUSTERED BAR CHART that only shows value if there's one selection made in a certain filter. Therefore when I have no selection I would like to have no data at all, to have a blank, clean screen in that position.
Instead I get this:
The title is correct but I don't want those lines and those points on the X axis. I know I could disable the gridlines or the X axis alltogether but I like to have them when, instead, I do have a model selected and data on my visual.
Is there some way I could correct this? Either in the visual's settings or in the DAX I wrote for that formula (which has an IF(HASONEFILTER) condition with a BLANK as the last argument in order to show nothing when I don't have a filter selected).
Thanks
Solved! Go to Solution.
Hello @HxH ,
yes there is a possible solution -> @MattAllington describes it here.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Hello @HxH ,
yes there is a possible solution -> @MattAllington describes it here.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef