Forum Discussion
Solved
Using measure as calculation on x-axis
I need to show uptake % against [Days From Go-Live], which is a differance between two dates calculation but is given me issues to display on a line diagram. From other forum posts I have seen that ...
Hello CarelJordaan ,
So in order to work as x-axis, you need to create the same measure but as a calculated column, thus you'll have numbers to view as days in x-axis.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
I managed to solve the problem by intorducing a new table that has a list of dates generated for each AG Zone and thus the existing measures could be used to create a calculated column for which the existing relationship work and would update to calculate the correct values for that AG Zone.
This video on generating date lists assisted me with the input from Idrissshatila .