Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
How to form a line which shows price difference of supplier A and B, they are not alway have same offering date?
raw data would be
A | B | |
1/1/22 | 11 | |
1/2/22 | 14 | |
1/3/22 | 15 | 18 |
1/4/22 | 16 | |
1/5/22 | 13 | 19 |
1/6/22 | 17 | |
1/7/22 | 20 | 26 |
Solved! Go to Solution.
@KevinYan You can create a measure and add it as new line in the chart:
raw data would be: (more clear below)
A | B | |
1/1/22 | 11 | |
1/2/22 | 14 | |
1/3/22 | 15 | 18 |
1/4/22 | 16 | |
1/5/22 | 13 | 19 |
1/6/22 | 17 | |
1/7/22 | 20 | 26 |
@KevinYan You can create a measure and add it as new line in the chart: