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!
What is on your X-Axis ?
Your measures are supposed to work on an axis value.
- DigitalAutomat5 years agoRegular Visitor
Fowmy At the moment there isn't anything but if I try to put something like a data/time this is the result:
It seems that all these values are unrelated and elaborated separately from each other...
- Fowmy5 years agoSuper User
DigitalAutomat
Have you created a relationship between the date table and the table where you have the data for the measures?