Forum Discussion
Matrix with a Slicer for the Values
I would like to have something like a slicer to control the values that are visible in the Matrix. The Slicer would have "To AF" and "To MG" then the user could only pick one and the matrix would adjust to the selection. See image for more detail. Any ideas how to do this?
If I can get this working I will try to put it on the intranet.
Hi Ssibbett ,
there is a community post on this topic.
If you provide sample data, I can also help you with the implementation.
Hi Ssibbett ,
You may try to create a new category table to filter.
1.My sample data is this.
Sampling Point Name
Date
To GF
To AF
3 Well
Wednesday, January 1, 2020
1
7
4 Well
Sunday, February 2, 2020
2
6
n Well
Tuesday, March 3, 2020
3
5
nd Well
Saturday, April 4, 2020
4
4
b Well
Tuesday, May 5, 2020
5
3
ly Well
Saturday, June 6, 2020
6
2
a Well
Tuesday, July 7, 2020
7
1
3 Well
Tuesday, January 1, 2019
5
7
4 Well
Saturday, February 2, 2019
5
7
n Well
Sunday, March 3, 2019
4
8
nd Well
Thursday, April 4, 2019
4
9
b Well
Sunday, May 5, 2019
3
9
ly Well
Thursday, June 6, 2019
3
6
a Well
Sunday, July 7, 2019
2
4
2.Create a category table by entering.
3.Create a measure.
To *F = SWITCH ( SELECTEDVALUE ( 'Category'[Category] ), "To AF", SUM ( 'Table'[To AF] ), "To GF", SUM ( 'Table'[To GF] ) )4.Create a slicer with Category column in the Category table and open Single select.
5.The visual is created as follows.
6.Then filter ‘To AF’ or ‘To GF’ through the slicer, and the result will be displayed in a single.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Ssibbett ,
You may try to create a new category table to filter.
1.My sample data is this.
Sampling Point Name
Date
To GF
To AF
3 Well
Wednesday, January 1, 2020
1
7
4 Well
Sunday, February 2, 2020
2
6
n Well
Tuesday, March 3, 2020
3
5
nd Well
Saturday, April 4, 2020
4
4
b Well
Tuesday, May 5, 2020
5
3
ly Well
Saturday, June 6, 2020
6
2
a Well
Tuesday, July 7, 2020
7
1
3 Well
Tuesday, January 1, 2019
5
7
4 Well
Saturday, February 2, 2019
5
7
n Well
Sunday, March 3, 2019
4
8
nd Well
Thursday, April 4, 2019
4
9
b Well
Sunday, May 5, 2019
3
9
ly Well
Thursday, June 6, 2019
3
6
a Well
Sunday, July 7, 2019
2
4
2.Create a category table by entering.
3.Create a measure.
To *F = SWITCH ( SELECTEDVALUE ( 'Category'[Category] ), "To AF", SUM ( 'Table'[To AF] ), "To GF", SUM ( 'Table'[To GF] ) )4.Create a slicer with Category column in the Category table and open Single select.
5.The visual is created as follows.
6.Then filter ‘To AF’ or ‘To GF’ through the slicer, and the result will be displayed in a single.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ssibbett ,
there is a community post on this topic.
If you provide sample data, I can also help you with the implementation.