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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.