Forum Discussion
Wrong graph
- 5 years ago
Hi DigitalAutomat,
Each of your measures needs to be associated with the date column on the x-axis so that the date column can be used as the context for the metric, otherwise, each measure will only show the maximum or minimum value.
For examples:
The following figure date column and sales column in the same table, they are displayed normally.The following chart shows that the date column and the sales column are not in the same table and are not linked。
After adding a relationship:
Or you can create measure as:
Measure = CALCULATE( MAX('Table'[Sales]), FILTER( 'Table', 'Table'[Date]=MAX('Table 2'[Date]) ) )The demo is attached, please try it.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Fowmy not really; I've just done what you can see in my last picture..