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.
Yes of course. Please see below:
The data source is an Excel sheet with four tabs - one for each of the years:
This is the separate Years table:
These are the relationships:
And the X and Y axis:
Is there any reason not to merge all the sales tables into a single table?
Funnily enough the original data source does have the year columns all on the same tab.
I changed the years so they were on separate tabs as I thought it might make it easier.
Having them all on the same tab would be better in hindsight though.
Is there a way of making the line chart work with the figures all on the same Excel tab?
In the screenshot below, the Sales total would be the figures for account numbers 1, 2, and 3 added together per year. So the 2023 Sales total would be cells C2, C3 and C4 added together. The 2022 Sales total would be cells D2, D3 and D4 added together, and so on.