Skip to main content

Power BI

New

Set a fixed width for bars in a bar chart to align with the row height in a matrix

Vote (2) Share
Cindy Botchis's profile image

Cindy Botchis on 11 Jan 2022 19:30:00

Put another way: Align records across different visuals when selecting an option in a slicer.


When we have a matrix and a bar chart (as an example), we may put them side by side so we can see them both together for a single dimension member/category. When selecting different dimensions/levels from a slicer, it would be useful for the records to 'stay aligned'. In a matrix, all the rows are the same size, regardless of whether there are 5 rows or twenty rows. But in the bar chart, the bar sizes change. So a bar chart with twenty rows will have 'thinner' bars than one with 5 rows.


Essentially, I want to be able to 'fix' the bar width to be the same as the width of a row in a matrix, so that I can have a category (e.g. "Bicycles") and read the matrix data and bar chart data across the Power BI page. Currently I can make this work for a single selection, but when you choose a slicer option with more or fewer categories, the alignment becomes skewed.

Comments (1)
Cindy Botchis's profile image Profile Picture

Sheeja T P on 26 Jul 2023 07:32:54

RE: Set a fixed width for bars in a bar chart to align with the row height in a matrix

Good idea ,need to allign the bar chart and matrix visuals if both are added together.Lot of manual work can be avoided.