Forum Discussion

Fern_21's avatar
Fern_21
Helper V
1 month ago
Solved

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? C...
  • pankajnamekar25's avatar
    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