Bar and line chart with table image

Bar and line chart with table

by Kishore Kadhirvelu

Power BI visuals
Microsoft PBI Certified
(2 ratings)
Pricing Free
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

    This visual is certified by Power BI

    At a glance

    Snapshot 1 of Bar and line chart with table
    Snapshot 2 of Bar and line chart with table
    Snapshot 3 of Bar and line chart with table
    By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of terms is governed by separate privacy and {4}.