Forum Discussion
Methods for a static x-axis
AoJueMingwrote:I have not managed to create a functional visualisation using the seperate table and data from one of the queries yet, so no.
Any suggestions on how to do that would be appreaciated.
I've just noticed that your 1-4 table is disconnected per your OP, connect it to each of your tables and put it as your x-axis as a starting point
AoJueMingwrote:I have not managed to create a functional visualisation using the seperate table and data from one of the queries yet, so no.
Any suggestions on how to do that would be appreaciated.
I've just noticed that your 1-4 table is disconnected per your OP, connect it to each of your tables and put it as your x-axis as a starting point
The problem with this, was that I ran into this:
(Moon being the 1x4 'satellite' table of 1-4 as the answer peramaters). I can only have one active relationship here. If I try to make active another relationship i get this:
(Which I don't understand).
So now I can get the effect I want with the 'Pears' query:
But I cannot activate the link between Moon and any of the other queries. Attempting to make the visualisations for any of the other queries simply gives the correct values for the 'Pears' query (as that is the query with the active relationship to Moon):
So now what I need to do is;
Find a way that I can make active the connections between Moon and Oraanges/Bananas/Apples, or
Accept that this data moddelling method is not how PowerBI wants to play and find something else.
Do I need to have a seperate Moon for each and every Question data set/query? Or can I use the same Moon for multiple questions/data sets?
And of course, as I said previously - Is there a better way to do this altogether? Is there any benefit to forcing all this data into a single query - or is building a gigantic web of relationships between multiple simple datasets/queries a legitimate method?