Forum Discussion
How can I align a bar chart with a synchronized KPI table using native Power BI visuals?
- 1 month ago
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
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