Hot to add a button to show values in column

[krypto6969]

Hi 

I have a power bi working fine but I would like to add a button that would show only the rows that have a value for the column 'blocking'

So it would only show rows that have a value for the blocking column. Click button again (or a different button) to remove the filter and show all rows. 

What is the best way to accomplish this?

Thanks!

[krypto6969]

I tried your recommendation but am getting the error " dax comparisons do not support....". Tired changing the data type but still got the error. Any idea on what to try next? thanks! 

[krypto6969]

Hi jgeddes

I tried your recommendation but am getting the error " dax comparisons do not support....". Tired changing the data type but still got the error. Any idea on what to try next? thanks! 

[jgeddes]

try replacing Query1[blocking_session_id] = "" with ISBLANK(Query1[blocking_session_id] in the IF statement

[Ashish_Mathur]

Hi,

Expand the filter pane and give a condition there of Non blanks for the Blocking column.

[jgeddes]

Not sure if it is the 'best' but I would create a calculated column that tests if the 'Blocked' column is blank or not. You can be as creative as you like with the return values of the test.

isBlocked = IF(yourTable[Blocked] = "", "notBlocked", "Blocked Values")

Then take that column and create a tile slicer and use the filter pane so that it only shows the "Blocked Values" option. 
You should now have the ability to select/deselect your blocked values filter.