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

(1 ratings)
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