Forum Discussion
Graphing two Quick Measures
- 7 years ago
Hi MattGlover ,
If you just want the data in the line graph to display correctly, you can try creating the following measure instead (1.3) Total Revenues per Capita YoY%:
mearsure = IF ( ISFILTERED ( 'Master (2dot0)'[LongYear] ), ERROR ( "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column." ), VAR __PREV_YEAR = CALCULATE ( 'Master (2dot0)'[Total Revenues per Capita], FILTER ( 'Master (2dot0)', 'Master (2dot0)'[LongYear].[Year] = 2017 ) ) VAR __THIS_YEAR = CALCULATE ( 'Master (2dot0)'[Total Revenues per Capita], FILTER ( 'Master (2dot0)', 'Master (2dot0)'[LongYear].[Year] = 2018 ) ) RETURN DIVIDE ( __THIS_YEAR - __PREV_YEAR, __PREV_YEAR )Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi MattGlover ,
You can check if the context in the matrix is consistent with the context in the graph.
I created a demo below and everything shows normal.
If not your case, please share your sample pbix file for us if you don't have any Confidential Information.
Here is the demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.