Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RilwanFlame
Helper III
Helper III

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:

RilwanFlame_0-1668463388318.png

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)
RilwanFlame_1-1668463532390.png

 

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 2
amitchandak
Super User
Super User

@RilwanFlame , Please explore, if field parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Hi @amitchandak  Thank you. The slicer is still not reflecting on the table according to selected, which is my initial post purpose. 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors