Forum Discussion
building decomposition trees using randomly generated input
You can create random numbers in DAX that get updated with each dataset refresh.
I would like to be able to create a tree using say, 16 random pairings in any given set.
Your example looks more like four pairs? Do the individual hierarchy layers need to be phonetically related?
Thank you for your response.
The example I gave wasn't entirely accurate; any tree that is drawn should select (randomly) from any given set, a number of pairs as needed. For example:
1 layer = 2 pairs
2 layers = pairs
3 layers = 8 pairs
4 layers = 16 pairs
5 layers = 32 pairs
beyond 6 layers, it may be difficult to fit everything on one page, or at a size that is legible.
A basic workflow would be as follows:
1) user selects 2 phonemes to compare, say, 'L' and 'R'. They may also like to select the number of layers/pairs
2) a tree is drawn (as shown in the example PDF). No one pair should be used more than once.
3) it would be nice to be able to 'refresh' or 'redraw' the tree as needed by clicking a button.
Here is what I came up with. I am pretty sure this is not what you intended, but that's how decomposition trees work in Power BI.
The random selections will work on the Power BI Desktop when you click "Refresh".
Thank you very much for the screenshot and attachment.
You're right - it's now quite what I'm after so it might be back to the drawing baord. An upshot of this is I've discovered Power BI (and how useful it is) and will be using it for some other ideas in the near future regarding data visualization. It might be a little ambitious but I'd like to try drawing some of the items discussed here:
https://datascience.stackexchange.com/questions/38264/visualizing-many-one-to-many-relationships
