Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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?
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
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |