Forum Discussion
mtrussardi
5 years agoFrequent Visitor
Filters
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 in...
AntrikshSharma
5 years agoCommunity Champion
mtrussardi use ALLSELECTED.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- mtrussardi5 years agoFrequent Visitor
Sorry but I am not familiar with that function. I would apply it in this case?
Thanks in advance
- AntrikshSharma5 years agoCommunity Champion
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.
- mtrussardi5 years agoFrequent Visitor
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.