Forum Discussion

nemo's avatar
nemo
Icon for Helper I rankHelper I
3 years ago
Solved

Dynamically change the field in a table based on filter selection

Hi All, I have these 2 tables in my PBI model   Table 1         Table 2 book topic 1 topic 2 topic 3   topic book 1 aaa 1 bbb 1     topic 1 book 2 aaa 2   ccc 2   t...
  • ddpl's avatar
    3 years ago

    nemo ,

     

    First you need to unpivot Table 1,

     

    After that you can create a matrix and you can slice it as you requested...