Forum Discussion
MangoMango
1 year agoFrequent Visitor
How to Make Date Filter Work in Columns for Matrix View in Power BI?
I have a matrix view, and a date slicer. When I select a month, I want the matrix to display all months' data from January 1 of the selected year's date up to the selected month. The filter works when I put the date field in rows, but not in columns. How can I make this work when the date field is in columns?
This is the filter I added to the matrix visual, and I set this to 'contains ‘TRUE’
MonthDateFilter1 =
IF (
[Selected Month end] >= MAX ( 'FactTable'[YearMonth] ) &&
[Selected Month Start] <= MAX ( 'FactTable'[YearMonth] ),
"TRUE",
"FALSE"
)
Hi,
I have solved a similar question in the attached file.
2 Replies
- Ashish_Mathur
Super User
- MangoMangoFrequent Visitor
Thank you. This is very helpful!