I am working on a practice report to try and get up to speed with Power BI. I have a table generated from an input file that has information about people.
The table has 4 columns, and one of these columns is "Age". The value in this column for any "person" is either their age as an integer, or blank, meaning their age is not included.
I need to have a slicer with the options "ageIncluded" and "ageNotIncluded" that filters the table based on whether a persons age is included or not. I know that for this I can make use of checking for blank/not blank values, but how can I created this slicer that will filter the table when an option is selected?
Any help is much appreciated. Thanks!
Solved! Go to Solution.
Thank you for your reply! This definitely seems like it should work, but for some reason I get only the "AgeIncluded" option in the slicer, and when I click it the table does not get filtered