Line graph with values doubled by the x-axis

Question

Good morning, how are you?Let's see if you can give me a hand...Context:Medical patient base... they can be divided into two statuses = News / StoppedIn turn, these two states are divided into rankings according to the reasons for which they are not used. and one more value is calculated which are the "on treatment" which is a subtraction between news - stoppedThe client asked me to put together a bar graph where each bar is a state and in turn divide those bars into the classifications (combine grouped bars with stacked bars)... The problem is that by putting the On Treatment measure as a line, I am doubling the value of it because of the x-axisAs you can see in June, there is twice the 68 because one is assigned to the news and the other to the stopped, but in reality only a 68 should appear... Who has any idea?

anonymous · Accepted Answer

Hi Syndicate_Admin&nbsp;,
Based on my testing, please try the following methods:
1.Create the sample table.

2.Drag the column into the line and chart visual.

3.Create the new measure to calculate on treatment values.
OnTreatment = CALCULATE(
        SUM('Table'[Value]),
        'Table'[Statuses] = "News"
    ) - 
    CALCULATE(
        SUM('Table'[Value]),
        'Table'[Statuses] = "Stopped"
    )
4.Drag the measures into the Line y-axis.

5.The result is shown below.

&nbsp;
Best Regards,
Wisdom Wu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Line graph with values doubled by the x-axis

2 Replies

Related content

Double X-axis with duplicates

dynamic x-axis based on filter

Double X Axis, Axis Values,

How to display ALL x-axis values AND order by x-axis value

Congested X-Axis Range