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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Coffee
Advocate I
Advocate I

the Legend Interferes with 'Hasonefilter' and 'Isfiltered' DAX functions

Hi All,

 

Background: I am trying to utilize the 'Hasonefilter()' and 'Isfiltered' DAX function to keep my line chart from displaying data until one of two columns is filtered. I have been able to do this successfully if I do not have anything in the Legend.

 

My function looks like this: 

 

SiteSelectCheck_child = IF(or(ISFILTERED([MAD_Site]), HASONEFILTER('Hub/Child'[CHILD])),1,2)

 

Issue: In my line chart I want 'Child' to be the Legend. When I put 'Child' in the legend it counts as a filter with the Hasonefilter() and Isfiltered DAX functions. So the Isfiltered function will always be true, And the Hasonefilter function doesn't seem to be working as expected.

 

Some images of what I have right now with this function. I have been able to get 2/3 of the scenarios below with different functions, but never all 3 to work.

 

When nothing is filtered. The chart without a Legend doesn't show any data, but the chart with a Legend does show data (need this to not show data).

image.png

 

When I filter the Mad_Site. it successfully shows data in both.

 

image.png

When I filter the Child. It successfully filters only the child.

image.png

 

 

Conclusion: I can get all 3 of these scenarios if I take out the legend on my line chart, but then I'm not displaying all of the Child values.

 

Any help would be appreciated!

 

“Without my morning coffee I’m just like a dried up piece of roast goat.”

-Johann Sebastian Bach

 

2 REPLIES 2
Bhavesh22
New Member

Hello after 6 years, Got the same problem, did you find a workaround?
v-haibl-msft
Employee
Employee

@Coffee

 

The DAX functions are working as expected. Maybe we can use some other formulas to get the desired result.

Could you please provide some sample data of your table, or share your PBIX file through online file service like OneDrive?

 

Best Regards,
Herbert

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors