Forum Discussion
Gusd8
Helper I
Helper IPower BI Visual, two field filter but using OR
Greetings, thank you for looking I have a visual that displays activities and there is a field called "Error" which is a yes/no field and then a separate field called "Error Message" which is a text...
Use a Visual-level-filter with a measure
If you want the filter logic cleanly and reuse it, you can create a measure like this:
ShowRecordFlag = IF( [Error] = TRUE() || NOT(ISBLANK([Error Message])), //Try with && if || is not working 1, 0 )Then use Visual-level filter:
-
Drag ShowRecordFlag into the visual’s filters pane.
-
Set the filter to "is 1".
-
v-venuppu
Community Support
Community SupportHi Gusd8 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.