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.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

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