Power BI Slicer Multiple Columns

Are you looking forward to learning about how to use one slicer for Multiple columns? Then this Power BI Tutorial will help you to achieve it. Here we will learn how to create a power bi slicer with multiple columns including various examples. Also covered the below-related headings:

  1. Power bi slicer with Multiple columns
  2. How to create power bi slicer multiple columns
  3. Power bi slicer multiple fields
  4. Power bi slicer format multiple columns
  5. Power bi slicer searches multiple columns
  6. Power bi slicer list multiple columns
  7. Power Bi slicer multiple date fields
  8. Power bi date slicer for multiple tables
  9. Power bi slicer sort by multiple columns
  10. Power Bi slicer across multiple columns
  11. Power bi two slicers same column

Power bi slicer with Multiple columns

  • In Power BI, the slicer works as a visual filter, which enables a user to filter and sort reports and displays only the selected information as per the requirement.
  • We use a Power BI slicer to filter the data on the Power BI report easily, and also we can have an option to unselect slicers to hide unwanted or unimportant data.
  • Power BI filters and Power BI slicers are different from each other, the slicer is a significant way to visually filter the data on a Power BI report easily.
  • We can also use a Power BI slicer with more than one column, it filters and displays the data for the multiple column fields.

Also read: How to merge columns in Power Query

How to create power bi slicer multiple columns

Let us see how to create a Power Bi slicer with Multiple columns in Power BI,

In this example, I am going to use the financials data as mentioned below: You can also download the financials Sample data from here.

  • Open Power bi desktop. Load the financial data by using the get data option.
  • From the visualization pane, Select the Slicer visual and the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual.
  • In the Fields section, drag and drop the Sales column and Country column from the field pane in both visuals as shown below:
How to create power bi slicer multiple columns
How to create power bi slicer multiple columns
  • When we add multiple columns to the power bi slicer, by default it will automatically display the arrow next to the items, click on the arrow to expand, to show the items in the next level.
  • Here the first level is the Country field and the next level is the Sales field.
create power bi slicer multiple columns
create a power bi slicer with multiple columns
  • Now filter any value from the slicer visual, and the values will be filtered and displayed in the table visual automatically.
  • We can also have an option to clear selections in the slicer visual if we select the clear selections option. The Slicer filter will be removed from the slicer visual.
  • In the below screenshot, we can see that the power bi slicer has multiple columns, and the selected country and sales value from the slicer visual is displayed in the Table visual.
How to create power bi slicer multiple columns example
How to create power bi slicer multiple columns examples

This is how to create a Power Bi slicer with Multiple columns in Power BI.

Also read: Power BI Create Table From Another Table

Power bi slicer multiple fields

Let us see how we can use the Slicer visual with multiple fields in Power BI,

If we want to filter multiple related fields in a single slicer, we can do it by using a hierarchy slicer.

  • Here I have taken the Product hierarchy which contains the product name column, country column, and also the segment column in the slicer visual.
  • Load the data by using the get data option. From the visualization pane, Select the Slicer visual and the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual. Here the slicer is in the type of dropdown slicer style.
  • In the Fields section, drag and drop the Product hierarchy and Sales column from the field pane in both visuals as shown below:
Power bi slicer multiple fields
Power bi slicer multiple fields
  • Now you can select the multiple columns, i.e. I have selected Product name( Paseo) and then select Country column.
  • When you expand the Country column you can see the next level options for Segments and then the Sales value. This is how the hierarchy slicer works.
  • Now select any value from the slicer visual, and the values will be filtered and displayed in the table visual automatically.
  • In the below screenshot, we can see that the power bi slicer has multiple columns, and the selected country and sales value from the slicer visual is displayed in the Table visual.
Power bi slicer multiple fields example
Power bi slicer multiple fields example

This is how to use the Slicer visual with multiple fields in Power BI.

See also  How to Merge Tables in Power BI

Read: Power BI Compares Two Columns in Different Tables

Power bi slicer format multiple columns

Let us see how we can format the power bi-slicer with multiple columns in the power bi desktop.

Yes, it is possible to format the Power Bi slicer visual’s style, title, and expand/ collapse icon.

Format the slicer style

  • There are two slicer styles presented, one is the list slicer style and the other now is the dropdown slicer style.
  • We can swap and choose any one of the slicer styles as shown below:
Power bi slicer format multiple columns
Power bi slicer format multiple columns

Format the title

  • To Change the title of any slicer, click on the formatting section in the visualization pane.
  • And then expand the slicer header, now under Title text, we can change or update the default title.
  • Once the title has been changed it will automatically reflect the selected slicer.
  • We can also change the font size, font style, and font color of the slicer header.
Power bi slicer format multiple columns example
Power bi slicer format multiple columns examples

Format the expand and collapse icon in the slicer

  • Power bi hierarchy slicer has some other formatting options, We can change the expand/ collapse icon or the caret sign or plus/minus sign from the default arrow sign.
  • To change the expand/collapse icon, click on the Formatting section in the visualization pane.
  • Expand the Hierarchy, then scroll down to Expand and collapse icon, from the dropdown select the style of the icon.
  • In the below screenshot, you can see the power bi-slicer expand/ collapse icon changed from the Chevron sign to the Caret sign.
Example of Power bi slicer format multiple columns
Example of Power bi slicer format multiple columns

This is how to format the power bi-slicer with multiple columns in the Power BI.

Check out: Power BI Sum Group by

Power bi slicer searches multiple columns

  • In the Power bi slicer visual, search functionality is not presented, So it is not possible to search the data in the slicer visual.
  • We can use the custom visual i.e. Text Filter, first you concatenated the multiple columns into one, then use the text filter visual for the search.

Power bi slicer list multiple columns

Let us see how we can see the slicer list with multiple columns in Power BI,

  • Here I have taken the Product hierarchy which contains the product name column, country column, and also the segment column in the slicer visual.
  • Open Power bi desktop. Load the financial data by using the get data option.
  • From the visualization pane, Select the Slicer visual and the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual.
  • Select the list slicer style, by default when you add the slicer visual to the Power BI report it will be in the list slicer style.
Power bi slicer list multiple columns
Power bi slicer list multiple columns
  • In the below screenshot, we can see that the power bi slicer has multiple columns, and the selected country and sales value from the list slicer visual is displayed in the Table visual.
Power bi slicer list multiple columns example
Power bi slicer list multiple columns example

This is how to see the slicer list with multiple columns in Power BI.

See also  Power BI Matrix Multiple Column

Check: Power BI Report Export to PDF [With 20+ Examples]

Power Bi slicer multiple date fields

Let us see how we can use the date slicer field for multiple field values in Power BI,

In this example, I am going to use the financial data, and in the date hierarchy slicer, I have selected the Month slicer, so that the data will be changed based on the selected month and displayed in the Table visual or Matrix visual.

  • Import the data into Power BI Desktop, and make sure the table that you are loading to the desktop has a date column in it.
  • From the visualization pane, Select the Slicer visual and add the date field to it, from the date hierarchy, you can select date or month, or quarter, from the date table into the slicer,
Power Bi slicer multiple date fields
Power Bi slicer multiple date fields
  • Now select the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual for the selected fields.
Power Bi slicer multiple date fields example
Power Bi slicer multiple date fields examples
  • In the below screenshot, we can see that the power bi slicer date fields, from the slicer visual for the selected month it is display country and sales value in the Table visual.
Example of Power Bi slicer multiple date fields
Example of Power Bi slicer multiple date fields

This is how to use the date slicer field for multiple field values in Power BI.

Read: Power BI Add Calculated Column [With Various Examples]

Power bi date slicer for multiple tables

Let us see how we can use a single date slicer for multiple tables in Power BI,

Here I have used two tables called financials and sales tables, make sure one column is common in both the tables so that we can make the relationship between the two tables.

  • Open Power bi desktop. Load the financial data by using the get data option.
  • Make sure the relationship between the tables in Power Bi,
Power bi date slicer for multiple tables
Power bi date slicer for multiple tables
  • From the visualization pane, Select the Slicer visual and choose the Between option and also select the chart visual so that if you filter any values in the Slicer visual the changes will be reflected in the selected chart visual.
  • Drag and drop the date hierarchy field into the slicer visual, and choose the between option. so that we can choose the from to option in the date slicer.
  • The sales by country chart display data from the financial table and the Sales by Product and Country chart displays data from Sales Table.
Power bi date slicer for multiple tables example
power bi connect slicer multiple tables
  • In the below screenshot, we can see that the power bi slicer date fields, from the slicer visual for the selected from date to date, applies a filter for both the table data
  • We can use the slider to choose the two between dates and check the results in the two different charts coming from two different tables.
Example of Power bi date slicer for multiple tables
Example of Power bi date slicer for multiple tables

This is how to use a single date slicer for multiple tables in Power BI.

Check: Power BI Matrix Multiple Column

Power bi slicer sort by multiple columns

Let us see how we can use slicer visual to sort by multiple columns in Power BI,

  •  To sort the values in a slicer based on multiple columns within the same table. Open Power bi desktop. Load the financial data by using the get data option.
  • From the visualization pane, Select the Slicer visual and the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual.
  • In the Fields section, drag and drop the Country column from the field pane in both visuals as shown below:
Power bi slicer sort by multiple columns
Power bi slicer sort by multiple columns
  • Now filter any value from the slicer visual, and the values will be filtered and displayed in the table visual automatically.
  • We can also have an option to clear selections in the slicer visual if we select the clear selections option. The Slicer filter will be removed from the slicer visual.
  • In the below screenshot, we can see that the power bi slicer has multiple columns, and the selected country from the slicer visual is displayed in the Table visual.
Power bi slicer sort by multiple columns example
Power bi slicer sort by multiple columns example

This is how to use slicer visual to sort by multiple columns in Power BI.

See also  How to Add Data Labels in Power BI? [With Examples]

Check: How to remove rows in power query editor [With various examples]

Power Bi slicer across multiple columns

Let us see how to see the Slicer across the multiple columns in Power BI,

In this example, I have used the financial table data to filter or sort across multiple columns in Power BI.

  • Open Power bi desktop. Load the financial data by using the get data option.
  • From the visualization pane, Select the Slicer visual and the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual.
  • In the Fields section, drag and drop the Sales column and Product column from the field pane in both visuals as shown below:
Power Bi slicer across multiple columns
Power Bi slicer across multiple columns
  • We can also have an option to clear selections in the slicer visual if we select the clear selections option. The Slicer filter will be removed from the slicer visual.
  • In the below screenshot, we can see that the power bi slicer has multiple columns, and the selected Product and sales value from the slicer visual is displayed in the Table visual.
Power Bi slicer across multiple columns example
Power Bi slicer across multiple columns example

This is how to see the Slicer across the multiple columns in Power BI.

Check: Power BI filter between two dates [With 15+ Examples]

Power bi two slicers same column

Let us see how we can use two slicers on the same column in Power BI,

Yes, it is possible to filter or sort the two slicers on the same column in Power BI. Here in this example, we have two slicers to filter and display data.

  • Open Power bi desktop. Load the financial data by using the get data option.
  • From the visualization pane, Select the two Slicer visuals and the two tables visuals so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual.
  • In the Fields section, drag and drop the Sales column and Product column from the field pane in one visual, in the same way, drag and drop the Sales column and Country column from the field pane in other visual, as shown below:
Power bi two slicers same column
Power bi two slicers same column
  • We can also have an option to clear selections in the slicer visual if we select the clear selections option. The Slicer filter will be removed from the slicer visual.
  • In the below screenshot, we can see that the power bi slicer has multiple columns filtered, and the selected Product and sales value from the one slicer visual is displayed in the Table visual.
  • In the same way, it filters and displays the data in the other slicer visual in the table visual as shown below:
Power bi two slicers same column example
Power bi two slicers same column example

This is how to use two slicers on the same column in Power BI.

Also, you may like some more Power BI Tutorials:

This Power BI Slicer Multiple Columns tutorial explains how to create a power bi slicer with multiple columns with examples, It Also covered the below-related headings:

  • Power Bi slicer multiple date fields
  • Power bi date slicer for multiple tables
  • Power bi slicer sort by multiple columns
  • Power Bi slicer across multiple columns
  • Power bi two slicers same column
>