Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
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".