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

Bar and line chart with table

by Kishore Kadhirvelu