Forum Discussion
How can I align a bar chart with a synchronized KPI table using native Power BI visuals?
Hi all!
Is it possible to recreate this chart in Power BI using only native visuals, considering that the user is working in a self-service BI environment and the requirement is the following?
Create charts with KPI tables underneath (for example, a bar chart showing P1 by country, with a table below that displays additional KPIs/values for each country, aligned with the corresponding country on the X-axis).
In other words, I'd like the matrix to be integrated with the chart, so the country labels are shown only once (on the chart's X-axis) instead of being repeated in the matrix. The solution must use only native Power BI visuals, as custom visuals are not allowed.
Thanks
Hello Fern_21
Yes, it's possible with native visuals only. The most reliable approach is to build a single Matrix instead of syncing two visuals put Country in Columns and your KPIs in Rows, with P1 as the first row, then apply conditional formatting - data bars on that row. This renders as horizontal bars that read like a chart, with the country header showing only once at the top, and since it's one object, alignment can never drift when the report is resized or filtered. If you need true vertical bars instead, you can pair a real Column Chart with a transposed Matrix (Country in Columns, column headers turned off since the chart already shows them), then manually align both to the same width and group them but this needs re-checking after any layout change since it's not inherently locked together. For a self-service environment maintained by multiple people, the single Matrix with data bars is the more robust choice.
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn |
Data With Pankaj - YouTube
4 Replies
Hi Fern_21 ,
Thanks for reaching out to fabric community.
Could you review the suggestion provided by pankajnamekar25 and let us know if you have any additional questions, we are happy to address.
Thanks!!
Hi,
Using only native Power BI visuals, there isn't a built-in visual that combines a bar chart with a perfectly aligned KPI table while displaying the category labels only once.
A few approaches you can consider:
Bar Chart + Matrix: Place them one above the other, use the same field (e.g., Country) and synchronize them with the same slicers. You can minimize the matrix row headers and adjust column widths to create the appearance of a single visual, although perfect alignment isn't guaranteed.
Small Multiples or Field Parameters may help simplify the layout, but they won't produce an integrated KPI table beneath the chart.
If the report is intended for self-service users, keeping the visuals separate is generally the most maintainable native solution.
Unfortunately, native visuals don't currently support sharing the X-axis labels between a chart and a matrix. This is why many implementations use custom visuals (such as xViz or Deneb), but since custom visuals aren't allowed, the closest option is careful visual alignment.
This related idea has also been discussed by the community:
https://ideas.fabric.microsoft.com/ (search for chart and table alignment / integrated chart visuals)
If Microsoft introduces a native visual that combines charts with aligned KPI tables, it would be a valuable enhancement for executive dashboards and self-service reporting.
If you found this reply helpful, please consider giving it a Kudos. If it answers your question, marking it as the Accepted Solution will help others looking for the same functionality.
Hello Fern_21
Yes, it's possible with native visuals only. The most reliable approach is to build a single Matrix instead of syncing two visuals put Country in Columns and your KPIs in Rows, with P1 as the first row, then apply conditional formatting - data bars on that row. This renders as horizontal bars that read like a chart, with the country header showing only once at the top, and since it's one object, alignment can never drift when the report is resized or filtered. If you need true vertical bars instead, you can pair a real Column Chart with a transposed Matrix (Country in Columns, column headers turned off since the chart already shows them), then manually align both to the same width and group them but this needs re-checking after any layout change since it's not inherently locked together. For a self-service environment maintained by multiple people, the single Matrix with data bars is the more robust choice.
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn |
Data With Pankaj - YouTubeHi Fern_21 ,
Could you please review the solution provided above and let us know if you have any further questions.
Thanks!!
