Filters

[mtrussardi]

Hi everyone,

I need to create a graph showing the unit cost of different products on the lines. However, I would like the graph to show the values only when I select the products on the filter instead of showing all the values as the default view. 

Please, any help would be much appreciated

[AntrikshSharma]

@mtrussardi use ALLSELECTED.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[mtrussardi]

@AntrikshSharma 

Sorry but I am not familiar with that function. I would apply it in this case? 

Thanks in advance

[AntrikshSharma]

@mtrussardi  Oh Okay, I assumed you are working with measures, I am at lack of creativity here, you will have to share the PBIX file to show where you are and what you want to achieve.

[mtrussardi]

@AntrikshSharma 

I simply have the column for products [Sales 'products'] with the columns for cost [Sales 'Unit Cost'] and date [Sales 'Date'] . The line on the graph shows the unit cost of the selected products, but when I don't select anything it shows the lines for all the products.