Forum Discussion
Zaytoon
3 years agoFrequent 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 ...
Zaytoon
3 years agoFrequent Visitor
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
3 years agoFrequent Visitor
Hi amitchandak please let me know if any further details are required 🙂