Filters

Question

Hi everyone,&nbsp;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.&nbsp;&nbsp;Please, any help would be much appreciated

antrikshsharma · Answer

mtrussardi&nbsp;use ALLSELECTED.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

antrikshsharma · Answer

mtrussardi&nbsp; 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 · Answer

AntrikshSharma&nbsp;&nbsp;Sorry but I am not familiar with that function. I would apply it in this case?&nbsp;&nbsp;Thanks in advance

mtrussardi · Answer

AntrikshSharma&nbsp;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.

Forum Discussion

Filters

4 Replies

Related content

Filter

Dynamic Filter

Inverse Filter

Override filters

Filter on Icons ?