Forum Discussion

Zaytoon's avatar
Zaytoon
Frequent Visitor
3 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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-fc4095ae9afd
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

 

Zaytoon's avatar
Zaytoon
Frequent Visitor
3 years ago

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

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

 

 

 

  • Zaytoon's avatar
    Zaytoon
    Frequent Visitor
    3 years ago

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