topic Re: Fixing the width of a column bar chart with several measures in the Y-axis in DAX Commands and Tips

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

Anonymous — Wed, 07 Sep 2022 09:17:15 GMT

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

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

Anonymous — Wed, 07 Sep 2022 09:34:51 GMT

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.

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

Anonymous — Wed, 07 Sep 2022 13:09:32 GMT

Hi Anonymous ,
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.

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

Anonymous — Wed, 07 Sep 2022 14:52:39 GMT

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.

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

v-easonf-msft — Mon, 10 Oct 2022 09:21:08 GMT

Hi, Anonymous

Can you share a sample file?

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

Best Regards,
Community Support Team _ Eason

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

Anonymous — Mon, 17 Oct 2022 07:35:45 GMT

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(...),

...

)

This worked. We can close this topic