1. Open Power BI Desktop:
Launch Power BI Desktop on your computer.
2. Load Your Data:
Click on Home > Get Data.
Choose your data source (e.g., Excel, SQL Server, etc.) and load your data into Power BI.
3. Select the Data for the Slicer:
In the "Data Pane", select the data fields you want to visualize. For example, you might choose Order Date.
4. Insert a Slicer:
Go to the "Build" pane on the right side.
Click on the "Slicer" icon.
5. Configure the Slicer:
Drag the desired fields to the appropriate areas in the Build pane
6. Customize the Card:
Use the "Format" pane to customize the appearance of your chart. You can change colors, add data labels, adjust axis titles, and more.
7. Save Your Report:
Once you're satisfied with your chart, save your report by clicking on File > Save As.
Load the Sales Data:
Import your sales data into Power BI.
Create the Slicer:
Select the "Slicer" from the "Build" pane.
Add Fields:
Drag the "Order Date" field to the "Field"
Customize:
Use the "Format" pane to adjust the chart's appearance.
By following these steps, you should be able to create a "Date Slicer" in Power BI that effectively visualizes your data
1. Prepare a table below slicer with columns - Order Date and Sales
Go to "Build" pane - select "Table" visual - drag "Order Date" to "Columns" - drag "Sales" to "Columns" - now try selecting different categories in the slicer - the table shows data as per the date selected in the slicer - to clear the selection of slicer, click on the small "Eraser / Clear selection" icon in the slicer
2. Formatting in Date Slicers
In the "Format" pane - go to "Options" - click on the dropdown under "Style" option - Select and try different options like Vertical list, Tile, Between, Before, After, Dropdown, Relative Date - Apply and try various styles to change look of your visual.