Connect two line values into one line

[CT1]

Hello,

Hope you are doing great, It is my first time using the community help and not sure if my explanaiton is clear enough.

I have been working with my Power Bi dashboard, using line and clustered column chart, dates are in the shared axis, I would like to reflect values on one line,  values on A until Jan 2 and then from Jan 3 the values on B. 

Dates	A	B	Result
1/1/2022	10%	8%	10%
1/2/2022	11%	10%	11%
1/3/2022	10%	9%	9%
1/4/2022	12%	4%	4%
1/5/2022	13%	3%	3%

Thanks in advance,

Regards

[v-zhangti]

Hi, @CT1 

You can try the following methods.

Measure A = 
IF(DATEDIFF(SELECTEDVALUE('Table'[Dates]),"2022/1/3",DAY)>0,SELECTEDVALUE('Table'[A]),BLANK())

Measure B = 
IF(DATEDIFF(SELECTEDVALUE('Table'[Dates]),"2022/1/3",DAY)<=0,SELECTEDVALUE('Table'[B]),BLANK())

Replace Measure A and Measure B with the original lines A and B in the figure.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.

[CT1]

Hello @v-zhangti,

It is almost there, the challenge now is that Table(A) and Table (B) are actually measures, and I wont be able to use the measures that you recomended me.

Can you help me with that please?

Thank you for your help!

[v-zhangti · Accepted solution]

Hi, @CT1 

I wrote A and B as metric A2 and B2 respectively, and the new metric is also based on A2 and B2. Do you see if it fits your situation this time?

Measure A = IF(DATEDIFF(SELECTEDVALUE('Table'[Dates]),"2022/1/3",DAY)>0,[A2],BLANK())

Measure B = IF(DATEDIFF(SELECTEDVALUE('Table'[Dates]),"2022/1/3",DAY)<=0,[B2],BLANK())

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NimaiAhluwalia]

Hello @CT1 

Can you please highlight a little more on the requirement with some visual representation of the desired output.

[CT1]

Hello @NimaiAhluwalia, here is my challenge, I have two metrics the old one and the new one, I want that the old one reflect until February nothing after and the new one from march on but nothing previous that date.

both of them are combination of some metrics thats way they will show numbers all the time.

Do you have any idea of how I can do this? 

Thank you for all your help !!

[arvindsingh802]

Is there any specific condition to be followed
If not, have in Old metric add filter for dates less than 28th Feb 2022 and in New metric dates greater than 28th Feb 2022

[CT1]

I tried to create a filter but I couldnt make it work, once I put those filters the data is not complete because it will follow before or after that metric.

Any idea ?