Forum Discussion
Building dynamic matrix from tabular model
Hi all, I have a question regarding building "dymanic" matrixes in a PBI report depending on intervals in a underlying table. The easiest way to explain is showing you how the data is structu...
TomMartens
Super User
Super UserHey,
this is an interesting task, can you please upload an excel file that contains your sample data to onedrive or dropbox? This would be helpful to easily recreate a PBI model.
I'm wondering about the data in your fact data especially the rows 19 and 20 from the diameter it could be either Matrix 1 or Matrix 2. From the length it just fits to Matirx 1.
Does this mean it will be just Matrix 1
Regards
Tom
Hi!
Here is a link to the sample data:
Regarding your question, those could be either in matrix 1 or in matrix 2. Regardless of which matrix the user selects in the slicer, those rows will be shown.