Power BI
NewSet a fixed width for bars in a bar chart to align with the row height in a matrix
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)
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.