Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |