Forum Discussion

Johnsnowlife's avatar
Johnsnowlife
Icon for Helper III rankHelper III
8 years ago
Solved

Creating lookthrough from 1 Fact table to another Fact table

I have 2 Fact Tables and I want to be able to create a pie chart with a hierarchy using the info from both tables. Fact Table 1: Is a Client Table showing the investment products the client owns.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Johnsnowlife,

    Please review this modified PBIX file.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Johnsnowlife,

In the Pie chart, when you drag Market Value to Values if the chart, each time you drill down to a different hierarchy level, the chart will show you market value of the current hierarchy level, in this case, it is not possible to show you weighted percentage held value in  the lowest level of the hierarchy.

If you want to show weighted percentage held value, you can drag the weighted percentage held measure/column to Tooltips of the pie chart. This way, when you drill down to each hierarchy level, pie chart will show  you both market value and show weighted percentage held value after you hover mouse over the chart.

 
Regards,
Lydia