How To Add A Date Slicer In Power Bi

by

To add a date slicer in Power BI, you can follow these steps:

  1. Open your Power BI Desktop application and load the data you want to analyze.
  2. On the right side of the screen, you will find the “Visualizations” pane. Click on the “Slicer” icon to add a slicer to your report canvas.
  3. In the “Fields” pane on the right, select the date field that you want to use as a slicer. Drag and drop it into the “Values” section of the newly added slicer.
  4. Customize the appearance of the slicer by selecting different options in the “Format” section of the “Visualizations” pane. You can choose the type of slicer (Dropdown, List, Between, etc.), set the date range, and select the style of display.

Here’s an example of how to add a date slicer in Power BI using a sample dataset: 

    
      <html>
      <head>
          <title>Power BI Date Slicer</title>
          <link rel="stylesheet" type="text/css" href="styles.css">
      </head>
      <body>
          <div id="reportContainer"></div>
          <script type="text/javascript" src="powerbi.js"></script>
          <script type="text/javascript">
              window.onload = function() {
                  var embedConfig = {
                      type: 'report',
                      accessToken: 'your_access_token',
                      embedUrl: 'your_embed_url',
                      tokenType: models.TokenType.Aad,
                      id: 'your_report_id',
                      permissions: models.Permissions.All,
                      settings: {
                          filterPaneEnabled: false,
                          navContentPaneEnabled: true
                      }
                  };

                  var reportContainer = document.getElementById("reportContainer");
                  var report = powerbi.embed(reportContainer, embedConfig);

                  report.on("loaded", function() {
                      console.log("Report loaded");
                  });
              }
          </script>
      </body>
      </html>

In the above example, you need to replace the placeholders with the actual values for your report. You can obtain the access token, embed URL, and report ID from the Power BI service.

Remember to include the necessary CSS styles and the Power BI JavaScript library for embedding reports.

Once you have completed the steps and customized the slicer, you can publish or share your Power BI report with others who will be able to interact with the date slicer and filter the data based on their selections.

I hope this helps! Let me know if you have any further questions.

Read more

Leave a comment