Connect slicer to a new report

To connect a slicer to a new report in Power BI, you can follow these steps:

Step 1: Create a new report

• Go to the Power BI Service and click on the "Create" button.
• Select "Report" from the dropdown menu.
• Choose a name and description for your report, and click "Create".

Step 2: Add a slicer to the report

• In the report canvas, click on the "Visualizations" pane and select "Slicer" from the list of available visualizations.
• Drag and drop the slicer onto the report canvas.
• In the "Slicer" pane, select the field you want to use as the slicer (e.g. a date field, a category field, etc.).

Step 3: Connect the slicer to a dataset

• In the "Slicer" pane, click on the "Modeling" tab.
• Select the dataset you want to connect the slicer to from the dropdown menu.
• If you want to connect the slicer to a specific table or query in the dataset, select it from the "Table" or "Query" dropdown menus.

Step 4: Configure the slicer

• In the "Slicer" pane, you can configure various settings for the slicer, such as:
  • The level of detail you want to show (e.g. day, month, year, etc.).
  • The format of the slicer (e.g. dropdown list, checkboxes, etc.).
  • The default selection for the slicer.

Step 5: Add a table or chart to the report

• In the report canvas, click on the "Visualizations" pane and select a table or chart visualization (e.g. "Table", "Column Chart", etc.).
• Drag and drop the visualization onto the report canvas.
• In the "Modeling" tab of the visualization pane, select the same dataset and table or query that you connected to the slicer.

Step 6: Connect the table or chart to the slicer

• In the "Modeling" tab of the visualization pane, click on the "Fields" tab.
• Select the field that you want to filter based on the slicer selection.
• In the "Filter" dropdown menu, select "Slicer" and choose the slicer you created earlier.

Step 7: Preview and publish the report

• Preview the report to ensure that the slicer is working as expected.
• Publish the report to the Power BI Service or save it as a file.

That's it! With these steps, you should be able to connect a slicer to a new report in Power BI.