Forum Discussion
Use Parameter to filter specific values from same column
Hi, I got a graph which I am trying to filter with a parameter. One part of my parameter is based on a column with 3 different values Tier 1 Tier 2 and Tier 3. And I am only trying to use a filter...
Anonymous , You can also use field parameter in filter to show the value of selected parameter and filter that for Tier1 and Tier 2.
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-202587d4dedbOr use a measure with Tier1 and Tier 2.
Calculate([Measure],filter(Location, Location[Tier] in {"Tier1 ","Tier2"}) )
Hi amitchandak,
thank you for your response! The Measure worked! I thought if I am using a filter the measure will add up the values to one value.
Thank you!