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

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
Zaytoon
Frequent Visitor

Field Parameter and Slicer Connection

i created parameter field that contains two fields and created relationship between main query and parameter, however when i use  field in main query as slicer it doesnt reflect on the parameter, so i have to make the slection from the parameter slicer itself:

Zaytoon_0-1674560294305.png

what i was expecting is that matrix shows value in percentage or decimal based on my attribute selection since its connected with parameter but it only shows % or decimal when i make the selection from the parameter slicer

3 REPLIES 3
amitchandak
Super User
Super User

@Zaytoon , why there is only on measure in the parameter? Share your measure formula something seem wrong

 

 

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

 

Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ


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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Many Thanks Amit,

"

Measure =
DIVIDE(SUM('Table1'[Source 1]), SUM('Table1'[Source 2]))" the formula is the same for both measures however one is in % and another one in decimal.

they are actually 2 fields in the parameter, however only one appeared as i have relationship between the slicer that read from query and the parameter slicer
after clearing selection of slicer attribute both measures appeared. while i wanted one of them to get selected based on my attribute slicer selection

Zaytoon_1-1674567233870.png

the below is the set relation between main query and parameter:

Zaytoon_2-1674567383986.png

 

 

 

Hi @amitchandak  please let me know if any further details are required 🙂

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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