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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

 

Share with Power BI Enthusiasts: 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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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