Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
arashaga
Helper I
Helper I

Problem with conditional filtering using DAX

I have two slicers and a bar chart. I would like to show the bar chart only and only when there is a selction on both slicers. So for that I created a DAX function as below: 

 

 

ADD_Filter Condition = if (HASONEFILTER(SQL_SEEKUT_TX_UNDRGRD_GRAD_WAGE_LOAN[CIP6Title])&& ISFILTERED(SQL_SEEKUT_TX_UNDRGRD_GRAD_WAGE_LOAN[inst_name]), "Yes", "No")

I added the ADD_Filter_condition to the barchart filter and put the condition that it would show the chart when it is equal to "Yes":

3.PNG

 

 

 

Now, the chart shows when I select the first and second slicer and turns off when I select the first not the second slicer but the problem is that it doesn't work when I select the second one not the first one. I added a card visual below the bar chart to show that what ADD_Filter_Condtion has when I select the second slicer and not the first one(the case that filter doesn't work) and it says the values is NO so naturally the bar should not show up but it does. I can't wrap my head around this and it seems like a bug. Does anyone have any idea about this? (Below is the screenshot of different cases)

 

The case that works:1.PNG

 It works also when both are selected: 2.PNG

 

 

 

This is the case that it doesn't work ( the second one is only selected):3.PNG

 

 

 

 

2 REPLIES 2
dedelman_clng
Community Champion
Community Champion

Try HASONEVALUE instead of HASONEFILTER at the beginning of your measure.

 

Hope this helps

David

Thanks @dedelman_clng but it didn't work.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

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.