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.
I have a table of employers and 3 filters by name, second name and department.
I need to make my table to show results only if any of these filters are being active.
How I can do it?
Solved! Go to Solution.
hi, @Dmitriy
You could use ISFILTERED to create a measure get your requirement.
if name, second name and department are in your result visual?
If no, you could add a measure like this
Measure = IF(ISFILTERED('Table'[name])=TRUE()||ISFILTERED('Table'[Second Name])=TRUE()||ISFILTERED('Table'[department])=TRUE(),1,2)
Then drag it into visual level filter and set filter is 1
If yes, you need add a new name, new second name and new department column and use them in visual
and then drag measure into visual level filter and set filter is 1
Result:
Best Regards,
Lin
hi, @Dmitriy
You could use ISFILTERED to create a measure get your requirement.
if name, second name and department are in your result visual?
If no, you could add a measure like this
Measure = IF(ISFILTERED('Table'[name])=TRUE()||ISFILTERED('Table'[Second Name])=TRUE()||ISFILTERED('Table'[department])=TRUE(),1,2)
Then drag it into visual level filter and set filter is 1
If yes, you need add a new name, new second name and new department column and use them in visual
and then drag measure into visual level filter and set filter is 1
Result:
Best Regards,
Lin
Hi,
Do you know how I can do this where if you only use one of the filters then the other columns stay blank in a table?
My report has a filtering page, and in the report pages I have a 'Selected FIlters' key which should be blank unless a filter has been used. The key is made up of several one column tables, one for each of the filters. I'd like them to only show a result if that field has been used as a filter. All of these fields are in the same table.
(Courses)
(Qualifications Type)
(Field of Education)
So far I have been able to make all tables blank using ISFILTERED on one of my fields (Courses), but only this filter returns results in the tables. When I use the other filters nothing appears in any of the tables.
I have used the solution in this thread but only the (Courses) tables is blank and the others are now showing all thier data. When I use a filter all of the tables show filtered results, but I want the other tables to remain blank unless used.
Is there a way to do this?
Thanks
hi leishka
I need same thing , do you find any way to do that please?
great explanation, thank you
Should be able to use ISFILTERED: https://docs.microsoft.com/en-us/dax/isfiltered-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |