Dynamic measures and blank spaces in column chart

[mau_habert]

Hi,

I created one visual with many measures into the Clustered Column Chart. All measures can be dinamically selected by the user to be shown in the chart at the same time, as in the following picture (where the 9 measures are shown to each X company name):

So far ok. The problem is: when I start to deselect some measures that I dont want to see in the chart, Power BI "reserves" one blank space to the deselected measure, and the chart turns into an unpleasant fashion, with lots of white spaces between X values, as in the following picture (where I selected just one measure):

Here is the Dax formula that I'm using to each "dynamic measure" (they are all the same logic):

medida dlr = 
Var LogicTest = 
COUNTROWS(DISTINCT(
    FILTER(ALLSELECTED(Variaveis_Receita_Tabela_2),
        Variaveis_Receita_Tabela_2[Valor 2] = "DLR"
    )
)) = 1
Return
IF (
    LogicTest,
    sum(econ_ind_sustentabilidade_tab_2[dlr]),
    BLANK()
)

Do you know if there is some way to get rid from those white spaces when the measures are deselected?

Thanks

[Anonymous · Accepted solution]

Hi @mau_habert ,

Please select the related column chart and navigate to Format pane. Find X axis options to adjust the value of Inner padding just as below screenshot.

Best Regards

[PhilipTreacy]

Hi @mau_habert 

No I don't believe you can change this spacing between columns dynamically like that, it's the way the visual works.

Regards

Phil