Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Anonymous
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
@Anonymous,
Could you please share sample data of your table here and post expected result here?
Regards,
Lydia
This is the principal page of the report and we have differents filters..
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 @Anonymous
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
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.
@Anonymous,
It is not possible to achieve your requirement. As a workaround, you can export the Power BI report to PPT .
Regards,
Lydia
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |