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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors