Forum Discussion

swaroopkumarmg's avatar
swaroopkumarmg
Helper II
4 years ago
Solved

Combine values from different table visual to a single table visual

Hello there.    Problem: i have a single data set - data is in a single excel sheet, but I have to create different pivots from the same data set.  once I have the pivots ready I need to take the ...
Need Help
swaroopkumarmg's avatar
swaroopkumarmg
Helper II
4 years ago

Hi Lucien,

 

thanks for giving this a try.

 

What I'm actually looking at is this.

 

here Male & Female tables are matrix tables and the other one is a normal table visual. 

in the actual report, I'm working on, I have 10+ pivots in my excel file, I do not want to create 10+ tables in Power BI. Rather retrieve data from only one data table (sheet1)

 

is there a way for the Normal table to reference columns from both the Matrix tables? like how GETPIVOTDATA can be used in excel?  the reason is each of those pivots has a different kind of filtering.