Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI

Hello,

 

I have multiple tables with same number of columns and same column names as well. 

 

Ex: Table1

Name Date Age Year Country

abc    23/02  12   2000  cde

bcd   24/02    13  2000  vcd

 

Ex: Table2

Name Date Age Year Country

abc    26/02  12   2001  cde

bcd   28/02   13  2001  vcd

 

The year in table1 is always 2000 and table2 is 2001.

I appended all these tables into one big table. I used this appended table for visualisation by keeping a filter option on year. So, that, when I click 2000 then all visualisation shows for year 2000 and if I select 2001 then all visualisation shows for  year 2001.

 

But, when I append this multiple tables into one single table then the data size of this appended table is very large and not an effecient way. Is there any other effecient way where I can change year and visualisations changes accordingly.

 

Thanks in advance!

  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    At present, the best way is probably to append the corresponding table in the power query. Then add the year to the slicer in the desktop, and display a specific screenshot by filtering a specific year.


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies