Hello,
How can I filter specific data?
I want to delete or want to show the data excluding ("All") in the graph.
I have tried to set the range min/max but it didnt work.
I want the graph to show the data starting from -500 and assending order.
can you please help me out eith this.
Thank you,
Sachin
Hi,
can you add more details ? the dimension, the expression.. the qvf file ?
Hello,
I am sorry, cannot add qvf file.
The dimensions are Customer name and Gross margin
And the expression in gross margin is
((Sum({$<[Year]={"2017"}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"}>}[Gross Margin Actual Year])))
Regards,
Sachin
Yes & I want to exclude only that value in the graph and show the remaininng values.
so here it is:
((Sum({$<[Year]={"2017"},Customer-={'All'}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"},Customer-={'All'}>}[Gross Margin Actual Year])))
Exclude dimension value in your SetAnalysis
((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))
- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))
sachinnataraj didn't you tell me that the dimension is called Customer ?
it is not the same answer i gave you here ?
Yes it is the same, but there was a " missing. I figured it out later.
Any how thanks a lot.
Sachin