cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

 

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors