![]() ![]() Let’s now filter information on our clustered column chart displaying total sales for different provinces.įor example, let’s keep the minimum date as the default date and make the maximum date (December 15th, 2020). You can also enter the minimum and maximum dates in the text fields directly if that is faster.īy default, the slicer contains the minimum and maximum date values from the Ship Date column that you used to create this slicer.įiltering Information Using A Date Slicer The slicer contains a horizontal range bar where you can drag the left and right circles to set the minimum and maximum date range limits, respectively. You should now see the following slicer in your reports view. ![]() In this article, we will create a slicer based on all the fields. If you remove the Day sub-field, the minimum unit for filtering date will be the Month field. If you click on the reverse carrot symbol (down arrow) to the right of the Ship Date field name, you will see that the date consists of Year, Quarter. The chart shows the total sales for different provinces in our dataset.įor example, you can see that 3 million of total sales belong to the Ontario province.Ĭlick the Slicer icon from the Visualizations pane.ĭrag and drop the Ship Date column to the Field option for the slicer, as shown in the screenshot below: Then drag and drop the Sales column to the Values field. īefore we do that, let’s create a chart that we will use as an example to filter information via a date slicer.įrom the Visualizations pane, click the icon for the Clustered column chart visual.ĭrag and drop the Province column from our dataset to the Axis field of our clustered column chart. To create a date slicer, you use the default Power BI slicer visual that you can find in the Visualizations pane in the reports view. In the following dialogue box, enter the link to the Github link containing your CSV file.Ĭlick the “ Load ” button to load the data in the reports view into Power BI. ![]() To import the data from this online link, click on the “ Get data ” button from the ribbon menu on the dashboard, type “ Web ” into the search bar and then select “ Web ” from the list of options. You can download the dataset for this article from this link: The other specific type of slicer is a hierarchical slicer. It can filter data based on a hierarchy of information such as year, quarter, month, days, etc. However, you can also treat it as a categorical slicer when filtering data based on a specific day, month, or year.ĭepending upon the dataset, the Power BI Date slicer is intelligent enough to explicitly find connections between different date levels. In this article, we will be focusing on the Power BI date slicer.Ī date slicer in Power BI filters information on visualisations using the date type data.įor example, you can plot a bar chart that shows the total sales values for a particular city between two date ranges with the date slicer.Ī Power BI date slicer is similar to a numeric range slicer by default. You can use a Power BI slicer to filter data based on categorical, numerical, as well as date information. We cover date slicers during our Power BI courses if you would like to learn more.Ī Power BI slicer is a visual element that allows end-users to filter information on different visualisations in Power BI. We will also look at creating a date slicer with hierarchies. This article looks at using a Power BI Date slicer on different types of Power BI visualisation. ![]()
0 Comments
Leave a Reply. |