cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MonicaElizondo Regular Visitor
Regular Visitor

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

Accepted Solutions
Highlighted

Re: help for put tables together

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
Moderator v-yuezhe-msft
Moderator

Re: help for put tables together

@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.
MonicaElizondo Regular Visitor
Regular Visitor

Re: help for put tables together

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

Moderator v-yuezhe-msft
Moderator

Re: help for put tables together

@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.
Highlighted

Re: help for put tables together

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

MonicaElizondo Regular Visitor
Regular Visitor

Re: help for put tables together

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.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,222)