Forum Discussion
Filter
Hi swalke,
Thank you for reaching out to the Microsoft fabric community forum.
As per your requirement, the final solution shows sales for all previous quarters regardless of the slicer, and only current quarter sales filtered by selected dates using a disconnected quarter table and a smart DAX measure. The matrix now accurately displays quarters in rows and categories in columns with correct values.
I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
Hi swalke,
Thank you for reaching out to the Microsoft fabric community forum.
As per your requirement, the final solution shows sales for all previous quarters regardless of the slicer, and only current quarter sales filtered by selected dates using a disconnected quarter table and a smart DAX measure. The matrix now accurately displays quarters in rows and categories in columns with correct values.
I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
Hi swalke,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.