Bar char resizing when values change

[qmestu]

Hi,

I have a report with a stacked bar chart visual that displays a column for each value of the X axis. Using the slicers on the report the count of values in the X axis can change. However this also changes the size of each column. Is there any way to keep a static size of each column?

Thanks.

[Anonymous · Accepted solution]

Hi @qmestu ,

This is by design. The size of each bar represents the magnitude of its value. A change in the numerical values will inevitably change the size of the bar. If you want bars with constant values, you can simply create a measure as below and apply it on the X-axis...

Measure =(special value)

If you only want the size of bar in the bar chart not effected by slicer, you can refer the following official documentation to get it.

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards