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 hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.