Report edit with 'If' Statements

[vandam2]

Hello Gang, not sure how to even ask this question, but i would like a way to filter and to add formatting to this report

i have two status's, Nuance_Status and PACS.Status

i would like to filter out any rows where Nuance_Status = Complete and PACS.Status = New,

if Nuance_Status = Complete and PACS.Status = blank, then keep on report but replace blank text with 'No Images'

not sure if i have to do something i powerquery, or if i can use a measure in PowerBI

hope this isnt too confusing, 

thank you in advance 

[j_ocean · Accepted solution]

Since both columns are in the same table I'd suggest PQ over a measure. Just add a logical column to determine an overall satus based on the possible combinations of the two other statuses. Then filter on that. 

A measure would be more like if you have the info in two different places and need a view that dynamically determines it live based on the other filters currently applied. It also can be a pain to filter by because it needs a visual context to evaluate, so can't be in a report slicer or page level filter.

[vandam2]

thank you, i used power query and then the if statement, so far so good..

also reviewed this youtube link

https://www.youtube.com/watch?v=HQ4RNJiVurI