https://store-images.s-microsoft.com/image/apps.16814.77fdf777-a68d-4ee9-aada-7bafa7092c82.45b536d1-b316-47fa-b559-ffa2e6f20494.10a63502-94ea-4c73-8d2c-2197a1331e91

Bar and line chart with table

by Kishore Kadhirvelu

Download SampleInstructions

Visualize bar and line chart with table integrated for detailed analysis

This custom visual for Power BI combines a bar and line chart with an integrated table, providing a comprehensive view of your data in a single visual. It's ideal for visualizing trends and relationships between different metrics while also displaying the underlying data in a tabular format for detailed analysis. It has the following features:

  • Combined Bar and Line Chart: Display two different measures on the same chart, one as bars and the other as a line, allowing for easy comparison and identification of correlations
  • Integrated Table: Show the underlying data used for the chart in a table below the chart, providing detailed values and enabling in-depth analysis
  • Interactive Elements: Users can interact with the chart and table, such as hovering over data points to see tooltips, and filtering data
  • Formatting Options: Customize the colors, fonts, and styling of the chart and table to match your report's theme
  • Support for Measures and Dimensions: Works with various measures and dimensions from your Power BI data model

    • How to Use:
  • Assign Data Roles: Drag and drop the appropriate fields from your data model into the following data roles:
  • Category (Dimension): The dimension to use for the x-axis (e.g., Product category, month)
  • Bar Values (Measure): The measure to display as bars
  • Line Values (Measure): The measure to display as a line
  • Configure Formatting: Use the visual's formatting option in the Format pane to customize the appearance of the chart and table

    • Data Requirements
  • One dimension for the Category axis
  • At least one measure for the Bar or Line Values (Up to 10 bars or lines)

    • Formatting Options
    Chart:
  • Bar Color
  • Bar Transparency
  • Line Color
  • Line Style
  • Marker
  • Legend
  • Data Labels

    • Table:
  • Font Size, Font Family, Bold, Italic and Underline
  • Turn on/off the series
  • Display Units

    • More customization features will be added in the future based on the feedback

    Visual capabilities

    When this visual is used, it
    • Can access external services or resources

    At a glance

    https://store-images.s-microsoft.com/image/apps.54690.77fdf777-a68d-4ee9-aada-7bafa7092c82.45b536d1-b316-47fa-b559-ffa2e6f20494.089de053-b9cb-45e1-b2ec-a0897db6fcb0
    https://store-images.s-microsoft.com/image/apps.35907.77fdf777-a68d-4ee9-aada-7bafa7092c82.45b536d1-b316-47fa-b559-ffa2e6f20494.037b7d8d-612b-4828-adb2-2d85a165bf46
    https://store-images.s-microsoft.com/image/apps.39995.77fdf777-a68d-4ee9-aada-7bafa7092c82.45b536d1-b316-47fa-b559-ffa2e6f20494.5967fdc3-0db5-4a7a-adff-22a95f50f782
    https://store-images.s-microsoft.com/image/apps.7667.77fdf777-a68d-4ee9-aada-7bafa7092c82.45b536d1-b316-47fa-b559-ffa2e6f20494.75a6e42b-3706-4fa3-8d0b-7cd38128d3e2