Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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.
It is not working. I cannot pull the measure to the X-Axis.
I created the following measure:
Hi, @Shifty1993
Can you share a sample file?
It's easier to take a look at the problem.
Best Regards,
Community Support Team _ Eason
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
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.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |