Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all 🙂
I'm trying to create a visual where 2 seperate lines join. Currently im at the following stage:
We can see the blue line does not connect to the red line.
The lines are based off the values in the following table:
Ideally I think i'd need to take the value from "MaxRawNegativeNew" for the 08/04/21 and replicate it in the "MaxRawPositiveNew" column in the corresponding date.
I'm just not sure how to achieve this, from the research I've done thus far I'm guessign it involves "FIRSTNONBLANK" but my knowledge of implementing this is limited.
Thanks in advance wizards!
Solved! Go to Solution.
Try creating a measure with the sum of both columns (or sum the measures if you have them):
Full line = SUM(Table[Column 1] + SUM(Table[Column 2])
Create a measure for the blue line (or use the corresponding measure):
Blue Line = SUM(Table[Column1])
add both measures to the line visual (Blue line measure on top in the values bucket)
Proud to be a Super User!
Paul on Linkedin.
Hi @Majad_Chowdhury ,
Create two measures and add the date filter conditions.
Set the type of x-axis to categorical.
Measure = CALCULATE(MAX(financials[ Sales]),FILTER(financials,financials[Date]<>DATE(2014,4,1)&&financials[Date]<>DATE(2014,5,1)))
Measure 2 = CALCULATE(MAX(financials[ Sales]),FILTER(financials,financials[Date]=DATE(2014,4,1)||financials[Date]=DATE(2014,5,1)))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try creating a measure with the sum of both columns (or sum the measures if you have them):
Full line = SUM(Table[Column 1] + SUM(Table[Column 2])
Create a measure for the blue line (or use the corresponding measure):
Blue Line = SUM(Table[Column1])
add both measures to the line visual (Blue line measure on top in the values bucket)
Proud to be a Super User!
Paul on Linkedin.
You cannot do this in DAX measures. You will need to add the two missing data points in Power Query or a calculated table and append them to the original data.
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |