powerbibusiness-intelligence

Scale clustered chart to use up space in visual - Power BI

I am currently working on a dashboard in Power BI that shows the row counts of tables that can be adjusted with a slider. I have used a clustered chart to create the visual. In principal I have been able to get the output I want. However I would like to finish off the formatting. My problem is that there is excess padding in the visual as shown below.

enter image description here

I would like to get rid of the spaces highlighted in Red. I would like the chart to 'fill' the space. Do you have any tips on how to do this? Thanks in advance

Solution

  • That's because you don't put any field to x-axis. That's by design.

    Here is a workaround for you.

    create a table.

    Table2 = SELECTCOLUMNS({"a","b","c","d","e"},"Category",[Value])

    then create a measure

    Final measure = 
SWITCH (
    SELECTEDVALUE (Table2[Category]),
    "a", [aa],
    "b", [bb],
    "c", [cc],
    "d", [dd]
)

    enter image description here