Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Looking to Create Column Slicer.

Hello All- 

I have several Columns i did like to reflect on my matrix table but I am thinking of putting them in a slicer and connecting the slicer to the matrix table as the fields basically have same variables. 

Here is my matrix table:

I created a dimension table for the columns in order to use as slicer.

Dimension Slicer =
Var IssuerCtryRisk = ADDCOLUMNS(VALUES('Monthly Positions'[Issuer Ctry Risk]), "Dimension", "Issuer Ctry Risk")
Var Creditor = ADDCOLUMNS(VALUES('Monthly Positions'[Creditor Ctry Risk]), "Dimension", "Creditor Ctry Risk")
Var UltimateParent = ADDCOLUMNS(VALUES('Monthly Positions'[Ult Parent Ctry Risk]), "Dimension", "Ult Parent Ctry Risk")
Return Union(IssuerCtryRisk , Creditor, UltimateParent)

 

How do i connect the slicer to my matrix table, in order to reflect on the table depending on the selected field (Country at Risk). 

 So far, I have : 

Selected Slicer =
VAR SV = SELECTEDVALUE('Dimension Slicer'[Dimension])
Return SWITCH(TRUE(), SELECTEDVALUE('Dimension Slicer'[Entity])
 
Hopefully this is clear.
 
Thank you all in advance. 
 

2 Replies