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 at this part of my parameter.
My parameter looks like this.
My graph looks like this.
What I am trying to do is to use my parameter which is currently filtering this 3 lines to filter only Tier 1 and Tier 2 so the Tier 3 line wont appear in my chart.
I cant use a simple filter because this would influence my other Parameter.
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"}) )
2 Replies
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!