Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@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
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.
@myou wrote:
https://www.dropbox.com/s/wzgj3sqojeiw7t1/sample1.pbix?dl=0
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?
I guess the date should be from the specific dates in the columns
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |