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

0 votes
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.
Feb 18, 2022 in Power BI by surbhi
• 3,820 points
3,336 views

1 answer to this question.

0 votes

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!

answered Feb 18, 2022 by CoolCoder
• 4,420 points

Related Questions In Power BI

+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,540 points
13,898 views
0 votes
1 answer

What are the components I need to excel to become a pro in power BI

Having knowledge about these topics is a must.  Power ...READ MORE

answered Oct 8, 2018 in Power BI by Kalgi
• 52,360 points
815 views
+1 vote
2 answers

403 error thrown by power bi report server when trying to get list of data sets

Hey @saranya, Try removing the header and ...READ MORE

answered Oct 29, 2018 in Power BI by Kalgi
• 52,360 points
4,878 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
2,802 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,206 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,674 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,540 points
1,419 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,360 points
1,596 views
0 votes
1 answer

If there a way to have the current month by default in a KPI representing MoM% in Power BI

The PREVIOUSMONTH DAX function can be used ...READ MORE

answered Feb 16, 2022 in Power BI by CoolCoder
• 4,420 points
2,249 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP