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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kealeya
Frequent Visitor

Filter on Report surface

Hi

I am making an attendance monitor for a school that wants to display students who have been absent on a Friday afternoon AND Monday morning.  Thesere the normal first and last days of the school week but there are some instances where the school week varies ie Thursday PM and Tuesday AM for example so these need to be selectable from a drop down menu. I have created this and it works

I have extracted the attendance data and placed it in a table and made some slicers that allow me to enter the attandance date range and the ability to select the appropriate day and  time.

However the data displayed shows people who have been absent Friday PM but not Monday AM and vice versa.

I am looking to implement AND logic to the drop down multiple select filter so that the only pupils that are displayed must meet both criteria and these criteria need to be editable so I cannot hard code it into the underlying data table.

I have looked on line and can find nothing that relates to this idea.  I think it must be available as it is the sort of functionality that I acn see being useful in a number of  other contexts.

Any ideasuld be gratefully appreciated

5 REPLIES 5
kealeya
Frequent Visitor

OK. I have redone the page that I am having a problem with.

I want to ba able to select a date range of a week, which I can do, select the two time periods I want to examine which I can do.  But I only want the rows that meet both criteria to appear.  At present I am getting pupils who meet one or both criteria.

PS How do I upload the file?

As this is a free account I cannot invite you to view it so how do we proceed?

Anonymous
Not applicable

Hi @kealeya 

 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OK. I have redone the page that I am having a problem with.

I want to ba able to select a date range of a week, which I can do, select the two time periods I want to examine which I can do.  But I only want the rows that meet both criteria to appear.  At present I am getting pupils who meet one or both criteria.

PS How do I upload the file?  Mine is a free account so I cannot invite anyone to view the report

Anonymous
Not applicable

Hi   @kealeya 

You can put your files in a dropbox, onedrive or googledrive folder and share the link with the community. Please provide more details with your desired out put and pbix file without privacy information.

 

Please refer to the related links for details:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

 

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.