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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I have a bar chart with count measure. I want to have a functionality where if user slices/filters the chart the way visual would present less than 10, i'd have to get rid of chart and have a popup/button that "Count is too small to highlight"
I know I can put a filter that measure is greater or equal to 10, but I still don't have any information for user that he is unable to do that. What would you suggest?
Solved! Go to Solution.
@Pbiuserr , Assume lines are based on legend column col1
then you can use this measure in visual level filter
if(countx(allselected(Dim), dim[col1]) <10, 0,1)
check for value =1, so it will become blank. you can keep a text box behind the visual with a message and make the background color transparent using this in the background color (Fx option) field value option
if(countx(allselected(Dim), dim[col1]) <10, "#ffffff00","#ffffff")
@Pbiuserr , Assume lines are based on legend column col1
then you can use this measure in visual level filter
if(countx(allselected(Dim), dim[col1]) <10, 0,1)
check for value =1, so it will become blank. you can keep a text box behind the visual with a message and make the background color transparent using this in the background color (Fx option) field value option
if(countx(allselected(Dim), dim[col1]) <10, "#ffffff00","#ffffff")