Hello,
is it possible to filter only last column in the table in which columns are not fixed but they depend on the slicer?
I have created the table where in rows are logins of the employees, in columns are numbers of weeks and in values is DAX measure.
I would like to filter only last column by values larger than 4900 and whenever I change the weeks (in slicer) filter will be applied to the last column
Example:
Slicer:
my table looks like this:
this is what I would like to get (values in week3 are larger than 4900)
then I change the weeks in the slicer:
my table now looks like this:
this is what I would like to get (values in week4 are larger than 4900)
is it possible to filter only last column in the table in which columns are not fixed but they depend on the slicer?
I have created the table where in rows are logins of the employees, in columns are numbers of weeks and in values is DAX measure.
I would like to filter only last column by values larger than 4900 and whenever I change the weeks (in slicer) filter will be applied to the last column
Example:
Slicer:
my table looks like this:
name | week1 | week2 | week3 |
login1 | 8576 | 7641 | 8765 |
login2 | 6765 | 3805 | 8842 |
login3 | 8823 | 5498 | 8002 |
login4 | 6808 | 8830 | 1525 |
this is what I would like to get (values in week3 are larger than 4900)
name | week1 | week2 | week3 |
login1 | 8576 | 7641 | 8765 |
login2 | 6765 | 3805 | 8842 |
login3 | 8823 | 5498 | 8002 |
then I change the weeks in the slicer:
my table now looks like this:
name | week2 | week3 | week4 |
login1 | 7641 | 8765 | 1352 |
login2 | 3805 | 8842 | 7503 |
login3 | 5498 | 8002 | 5003 |
login4 | 8830 | 1525 | 7531 |
this is what I would like to get (values in week4 are larger than 4900)
name | week2 | week3 | week4 |
login2 | 3805 | 8842 | 7503 |
login3 | 5498 | 8002 | 5003 |
login4 | 8830 | 1525 | 7531 |