Closed

[Eric_Zhang]

---

@myou wrote:

Hello, 

I have this matrix in Power BI, Date for Columns, Rows have stages, and values inside the table

So I put a slicer that has date, however , If I want to show October I dont want to show all the previous values. I only want to show the values in October and the previous values that are only  Won, For example, October filter will show this

But May Filter will show this 

PS: The above row could be different dates like this

---

@myou

In the matrix, the Month(Jan, Feb, Mar ect) would vary according to the date slicer, some will hide once they're not in the slicer dates window. So I think you'll not get what you expected in the pictures. There may be some cubersome workaround for your case, could you share some sample data, even better you can share a pbix file.

[Eric_Zhang]

---

@myou wrote:

@Eric_Zhang

https://www.dropbox.com/s/wzgj3sqojeiw7t1/sample1.pbix?dl=0

---

@myou

Thanks for sharing the sample pbix. I see in the pbix, there's a date slicer that crosses dates, not just as you mentioned "Octobor" or "May" selected, what would you like the measure to show for a dates duration? 

[myou]

I guess the date should be from the specific dates in the columns