close

How To Get A Hierarchical Slicer In Power BI?

Posted by Sas Chatterjee on May, 08, 2021 06:05

A hierarchy slicer is a way to filter your reports. You can use this tool in Power BI also. Now the question arises to your mind about adding a hierarchical slicer to your Power BI and how you can use it. We will discuss how you can use the hierarchical slicer in Power BI and how you can use this.

Where Can You Use A Hierarchical Slicer?

  • You can apply a hierarchical slicer in two versions of BI that BI Desktop and BI Service (SAAS BI). If you are willing to add and filter your multiple related slicers within a single slicer, you can do that by making a hierarchical slicer.
  • Now you must be thinking about how we can get a Hierarchical slicer in your Power BI. In the following blog, we will tell you how to get a hierarchical slicer, step by step. Let us start learning.
  • After adding multiple fields in the hierarchical slicer, it shows an arrow or chevron by default. You can notice this arrow beside those items that you can expand to deliver the next level.

If you select more than one child for a single item, there will be a half-circle chosen for the topmost object.

How To Format The Slicer?

The behaviour of the hierarchical slicer is still the same. There is an option to style your slicer according to your will. Also, you can make it on single select mode or swap somewhere between the list and dropdown. If you want to make changes in formatting, then there are some following ways to make changes.

  • To Change The Title
  • You can change the title of any slicer according to you. This procedure is especially useful in the hierarchical slicers. The name of the hierarchical slicer denotes the name of the list of hierarchical fields.
  • For example, the title of the hierarchical field is Type, Platform, and Name.
Hierarchical Slicer In Power BI
  • If you want to change the name, select the slicer and then select the formatting pane. You will see the present slicer’s name in the Title text box, under the slicer header.
Hierarchical Slicer In Power BI
  • Now you can give a new name to the text according to you.
Power BI Slicer
  • To change the icon

There are some other format options available in the hierarchy slicer. Use the arrow to plus/minus icon to make changes in the expanding icon or collapse icon by default.

  • First, you have to select the slicer than the format.
  • Now expand that item and select the icon of expand icon or collapse icon.
  • Select your item from Chevron, Plus/Minus, or Caret.
Slicer in Power BI
  • To change the identity

If there is not enough space for your report and you want to decrease the child’s child items. If the indentation is 15 pixels, then you may increase or reduce the pixels according to you.

  • Like other changes, first, select the slicer and then select the format.
  • Select the expand item and then drag the item to a smaller or larger indentation, or you can type the no. in the toolbox.
image

What are the limitations of using this hierarchical slicer?

Using the multidimensional model in Power BI, this system requires SQL server Analysis Services 2019 CU5 or Super DAXMD. It requires SQL Server Analysis Services 2017 or a new one for tabular models.

If you are looking for some professional help with using Power BI for Business Intelligence reports creation then you can reach out to EPCGroup for Power BI Consulting.

What is the Advantage of a Hierarchy slicer?

Below are some remarkable advantages of hierarchy slicer:

  • They add only filtered value.
  • In the form of text and background, you can apply conditional formatting on value and category.
  • You can get your reports filtered and also can expand the file according to you.

Final Words

So this is how you can efficiently filter out your reports with the help of a hierarchical slicer in Power BI. It will not only help you maintain a better record but will also lessen your efforts of doing it manually.

You can also check out the Power BI Cost for your reference.

[gravityforms id=41 title=”true” description=”false”]
<div class='gf_browser_chrome gform_wrapper exit_intent_popup_wrapper gform_legacy_markup_wrapper' id='gform_wrapper_41' > <div class='gform_heading'> <h3 class="gform_title">Exit Intent</h3> <span class='gform_description'></span> </div><form method='post' enctype='multipart/form-data' id='gform_41' class='exit_intent_popup gform_legacy_markup' action='/how-to-get-a-hierarchical-slicer-in-power-bi/' > <div class='gform_body gform-body'><ul id='gform_fields_41' class='gform_fields top_label form_sublabel_below description_below'><li id="field_41_1" class="gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" ><div class='ginput_container ginput_container_text'><input name='input_1' id='input_41_1' type='hidden' class='gform_hidden' aria-invalid="false" value='https://www.epcgroup.net/how-to-get-a-hierarchical-slicer-in-power-bi/' /></div></li><li id="field_41_9" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_9' >Full Name<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_text'><input name='input_9' id='input_41_9' type='text' value='' class='medium' placeholder='Full Name' aria-required="true" aria-invalid="false" /> </div></li><li id="field_41_6" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_6' >Email<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_email'> <input name='input_6' id='input_41_6' type='text' value='' class='medium' placeholder='Email Address' aria-required="true" aria-invalid="false" /> </div></li><li id="field_41_7" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_7' >Phone<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_phone'><input name='input_7' id='input_41_7' type='text' value='' class='medium' placeholder='Phone Number' aria-required="true" aria-invalid="false" /></div></li><li id="field_41_10" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_10' >Company Name<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_text'><input name='input_10' id='input_41_10' type='text' value='' class='medium' placeholder='Company Name' aria-required="true" aria-invalid="false" /> </div></li><li id="field_41_8" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_8' >Message<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_textarea'><textarea name='input_8' id='input_41_8' class='textarea medium' placeholder='Type your message here...' aria-required="true" aria-invalid="false" rows='10' cols='50'></textarea></div></li></ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_41' class='gform_button button' value='Submit' onclick='if(window["gf_submitting_41"]){return false;} window["gf_submitting_41"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_41"]){return false;} window["gf_submitting_41"]=true; jQuery("#gform_41").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_41' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='41' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_41' value='WyJbXSIsIjEwNTJhNGVmMWMyNzI3YTJmMjdiZTA1NjU4ZDMzYzY3Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_41' id='gform_target_page_number_41' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_41' id='gform_source_page_number_41' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div>