How can I set up cascading slicers in Power BI where one slicer s options depend on the selection of another

0 votes
How can I set up cascading slicers in Power BI, where one slicer’s options depend on the selection of another?

In my Power BI report, I’d like to create cascading slicers, where the options in one slicer adjust dynamically based on the selection in another slicer. I’m seeking guidance on setting up these interconnected slicers to refine data filtering, including the steps required to configure slicers for seamless interactivity between related data fields.
Nov 14 in Power BI by Evanjalin
• 7,080 points
35 views

1 answer to this question.

0 votes

In Power BI, cascading slicers are slicers that filter the selection available in the second slicer, making it dependent on what has been selected in the first. To do this, steps must be followed to create and manage the related filtering functions.

  • Define Relationships Between Tables: First of all, make sure that the data model created has correct relationships between the corresponding fields that will be used as cascading slicers. For instance, in the case of a slicer, such as “Country” and “City,” make sure that the two slicer fields are related tables (ex Country > City) so that the cascading effect can take place. This is important because, without this relationship, Power BI cannot cascade the slicers, as it uses relationships to cross-filter the data from different tables.
  • Create Slicers Individually: Create slicers for the fields that you need. For this, place the respective field, e.g., country and city, in the report canvas, and from the visualization pane, choose slicer visual. Order the slicers according to the sequence of meaning, i.e., the first parent slicer country will be placed above the second child city slicer.
  • Enable Cross-Filtering: By default, slider options should affect other slab options if any relationship is created in the data model. Check its suitability through the Edit Interactions feature under the Format tab in Power BI. For instance, click on the upper-class slicer country and ensure that it is ticked in the dependent class city slicer. This will prevent the slicer of the city from being active and showing all the options except for that pertaining to the country that has been selected.
  • Evaluation and Improvement of User Experience: Once setup has been completed, run some tests on your cascading slicers to check whether they work as intended. For instance, choose an item from the parent slicer (say, a specific country) and check that the child slicer (for example, cities) updates to display only the relevant selections. One may also wish to refine some of the proposed formatting options in order to improve the ease of use for the end user, such as providing appropriate titles or instructions to accompany the cascading selections.

Based on the aforementioned guidance, you should have achieved the ability to add cascading slicers into your Power BI report that automatically refresh when a user makes a selection. This will aid users in filtering information easily.

answered Nov 14 by pooja
• 6,670 points

Related Questions In Power BI

0 votes
0 answers
0 votes
0 answers

How can I automate data refreshes in Power BI, and what are the scripting options available?

How can I automate data refreshes in ...READ MORE

Oct 21 in Power BI by Evanjalin
• 7,080 points
140 views
+1 vote
0 answers

How can I automate data refreshes in Power BI, and what are the scripting options available?

How can I automate data refreshes in ...READ MORE

Oct 22 in Power BI by Evanjalin
• 7,080 points
76 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,620 points
1,434 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,342 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,739 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,520 points
1,511 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,350 points
1,658 views
0 votes
1 answer

How can I reduce the size of a Power BI file (PBIX) when working with large datasets?

Focusing on designing an appropriate model for ...READ MORE

answered Nov 8 in Power BI by pooja
• 6,670 points
68 views
0 votes
1 answer

How do I create custom tooltips that display different information based on the visual or data point in Power BI?

Designing personalized tooltips in Power BI is ...READ MORE

answered Nov 14 in Power BI by pooja
• 6,670 points
52 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