Forum Discussion
Filtering Table Data Based on certain conditions
Hi all,
Seeking help on the below.
In a table visual, I have data for WW45 and WW46 across various categories. I want to display data only when either the remarks or the fluctuation week-over-week (WoW) is not empty. If either the remarks or the WoW is empty, the corresponding data should not be shown.
Currently, I am unable to achieve this, as I have data for each WW.
1 Reply
Create a measure that implements your filter logic. Have it return 1 if you want the row to show, 0 otherwise. Add the measure to the visual level filters. Set the filter to "is 1".
