Power BI Giving users the option to include or exclude a type of data

Question

I'm working on my first Power BI report, which will analyze data on employee absences. A field called 'Absence Type' is included in the data, and it categorizes the type of absence that each record corresponds to.

I'd like my users to be able to see my report with and without the 'Pandemic' Absence Type. I can exclude it from all sites to hard-filter it, but that gives the users no control.

I considered utilizing a slicer with a new custom column, but I believe it would be too perplexing. If the Absence Type column had a 'Yes' or 'No' option for whether the absence was 'Pandemic,' users may examine the data without 'Pandemic' entries or just the 'Pandemic' entries, but not both.

They may easily deselect everything and get no results, even with a multiselect slicer.

I'd want to have either a 'Include Pandemic?' slider where they can select Yes or No (with Yes indicating everything and No indicating everything excluding Pandemic records) or a button where they can toggle the Pandemic records in and out of the visuals.

Answer 1

The best option, in my opinion, is to create a custom column with two values:

If the type is Pandemic, the term "pandemic" is used. If the type isn't pandemic, it's called non-pandemic.

As a hierarchical slicer, you'd utilize this new column + Absence Type.

This would allow the user to choose between the following options:

• Select all  (If the user deselects everything a select all will also be applied)
• Non pandemic only
• Pandemic only
• Any one or more types of absence

Unlock the Power of Data Visualization with Our Comprehensive Power BI Course!