Fixing the width of a column bar chart with several measures in the Y-axis

[Shifty1993]

Dear community,

I created several measures (called [0], ..., [20]) which calculates a y value for the x values 0, ..., 20.

Afterwards i visualised this with a bar chart. I put all measures in the y-Axis. 

The problem is to make the bars wider. How I already read in other common topics is that I need a x-Axis to do so.

So what I tried is to make a new table which is not working, because it won't accept the measure as a cell value.

Table = {

    (0, measure[0]),

    (1, measure[1]),

    ...

}

Somehow I have to find a way to make a relationship between the measure results and the values 0, ...,20.

x  -> y

0 - > measure[0]

1 - > measure[1]

...

I don't see any way to do this at the moment. Is there any trick here?

Best regards,

Phil

[Anonymous]

Hi @Shifty1993 ,
Have you tried 
measure2[0] = Calculate(measure[0],x=0)
measure2[1] = Calculate(measure[1],x=1)
measure2[2] = Calculate(measure[2],x=2)
.
.
.
and so on ...
And put the X values column in the X Axis.

[Shifty1993]

It is not working. I cannot pull the measure to the X-Axis.

I created the following measure:

x0 = CALCULATE([0], Punktzahl[Punktzahl] = 0)

Afterwards I tried to pull this x-Value for x=0 into X-Axis. But it is not being accepted.

[v-easonf-msft]

Hi, @Shifty1993 

Can you share a sample file?

It's easier to take a look at the problem.

Best Regards,
Community Support Team _ Eason

[Shifty1993 · Accepted solution]

Hi Eason,

I could already solve it.

I used a Switch True Condition to connect x-Values and y-Value. 

Switch(

    TRUE(),

    x-Value, CALCULATE(...),

    x-Value, CALCULATE(...),

    ...

)

This worked. We can close this topic

[Shifty1993]

Additional information: the function in the measures have several variable x  values. I just need the relationship between 0, ... , 20 and the result out of the measures.