cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

help for put tables together

Hello!

I have this issue, im not sure if this possible to do this:

 

I have three tables in the layout of my report, and differents filter, some filter are for all the report and some only for a table, the table 1 have a search filter, table 2 is a top of the value, table 3 is show the last values. Is a way to put together in only one table and keep the filters for each one?

Or a way to put 3 tables in only one excel archive?

 

Thanks for the help

Mónica

1 ACCEPTED SOLUTION

Hi @MonicaElizondo

 

ok I created a table with user, amount and state (instead of keyword)

for top and bottom i created a rank column, you already have top and bottom, based on amount and filtered top 3 and bottom 3

Then i created 3 tables with summarize function - one for top , one for bottom and one for search and added two more column

First column have top 3 in text for records in top 3 table, for bottom table i have bottom 3 for search table i repeated state column here (keyword in your case)

and one more column to sort things

 

Now instead of keyword in slicer we put this new column (Now you will have option to choose top 3 or bottom 3 or your normal search keyword)

 

I know its not exact solution to your problem, but you can get help with this. I will need more details to help you further.

 

find this Attachment : Merging Table.pbix

 

Thanks

Vinayak Kohli

 

 

 

View solution in original post

5 REPLIES 5
Microsoft
Microsoft

@MonicaElizondo,

Could you please share sample data of your table here and post expected result here?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This is the principal page of the report and we have differents filters..

6.jpg

 

The filters Country, Date and Test affect the 3 tables in the layout, and the Keywords filters affect only the Search Terms. The others two tables (TOP Amount and Rounded Amount) they do other calculations that have nothing to do with the filter keyword. 

 

I want to know if is possible put together the three tables but I don’t want the keyword filter affecting the other two (when I tried to put together with a merge, the top and the rounded are affected by the keyword filter. )

 

Or another possibility is if there is a way to download a single excel file that includes the three tables of the layout. The user don’t what to have 3 excels.

 

Thanks for the help

Monica

Hi @MonicaElizondo

 

ok I created a table with user, amount and state (instead of keyword)

for top and bottom i created a rank column, you already have top and bottom, based on amount and filtered top 3 and bottom 3

Then i created 3 tables with summarize function - one for top , one for bottom and one for search and added two more column

First column have top 3 in text for records in top 3 table, for bottom table i have bottom 3 for search table i repeated state column here (keyword in your case)

and one more column to sort things

 

Now instead of keyword in slicer we put this new column (Now you will have option to choose top 3 or bottom 3 or your normal search keyword)

 

I know its not exact solution to your problem, but you can get help with this. I will need more details to help you further.

 

find this Attachment : Merging Table.pbix

 

Thanks

Vinayak Kohli

 

 

 

View solution in original post

Thank you so much for all your help.
I was doing several tests with what you told me and sent and the example if it can work for me.
Thank you very much and have an excellent day.

@MonicaElizondo,

It is not possible  to achieve your requirement. As a workaround, you can export the Power BI report to PPT .

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors