How to write filter condition in Bar and Line graph?

[bhaveshp90]

Hello All,

I have created the visual as shown below

How Can I filter my Value (Line Axis) expression?

My query logic is

     Case when Report_Param = 'Sales' and Header_1 = 'Budget' and Header_2 = 'UDT' then sum(Value)

     else 0

     end as Value_USD; 

any help greatly appreciated.

thanks

Bhavesh

[bhaveshp90]

I have used this condition but it failed,

if(Report_Param = 'Sales' and Header_2 = 'UDT' and Header_1 = 'Budget', sum(Value), 0)

[MarioCenteno]

Try

=Sum({<Report_Param ={'Sales'}, Header_2= { 'UDT'}, Header_1= { 'Budget'}>}Value)

[bhaveshp90]

I tried your expression, but my line axis disappeared as shown below.

[MarioCenteno · Accepted solution]

Try

if(SUM({<[Report_Param] ={'Sales' }>}[Value]

SUM({<[Header_2] ={'UDT' }>}[Value]),

SUM({<[Header_1] ={'Budget' }>}[Value]

[bhaveshp90]

Perfect, this worked for me thank you.

Also, can you tell me how to count the project_no?

I am using count(project_no) in the bar expression which is showing incorrect no.

thanks

[MarioCenteno]

Would you use the same conditions to count the bars?

[bhaveshp90]

I have two expressions,

Count (Project_No),

Value(USD) =  (if(SUM({<[Report_Param] ={'Sales' }>}[Value]

SUM({<[Header_2] ={'UDT' }>}[Value]),

SUM({<[Header_1] ={'Budget' }>}[Value])

I have used the expression given by you for my Value, now the count of project_no is not accurate.

Should I use other condition for my count ?

[MarioCenteno]

I suggest you create another post with your new challenge and I will gladly try to help you

I would also like you to explain a bit more about the lodge of your expression, I think I am not understanding correctly.