Forum Discussion
Line chart will only display dots - no lines
Hi CH_MJR79
Please refer to the following solution.
Sample data
2022
2023
The relationship
Create a measure
Measure = SWITCH(TRUE(),SELECTEDVALUE('Date'[Dates].[Year])=2022,SUM('2022'[Total]),SELECTEDVALUE('Date'[Dates].[Year])=2023,SUM('2023'[Total]))Then just input the date column and measure to the visual.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have just created a new file, entered some dummy data and then added a line chart.
This line chart also just displays the coloured dots - no lines joining them up.
I am obviously doing something wrong but can't seem to work out what.
Here are the screenshots of the new file:
1. The chart:
2. The tables:
2022:
2023:
Date:
3. Relationships:
Hi CH_MJR79
Please refer to the following solution.
Sample data
2022
2023
The relationship
Create a measure
Then just input the date column and measure to the visual.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.