Forum Discussion
Parameter Selection through Buttons or DropDowns
Hey.
I am new to PowerBI and working on QoS Reports for 5 different regions/servers. A Single page of report contains different visuals from different databases. I want to create a main report in which i can select the region and the visuals are shown accordingly( using the data from that server). The Schema and all is identical.
I have created a parameter for each SQLInstance. When I import the template i am able to create 5 seperate reports but I want a single report that can change from the selection menu. I want to choose the region name and the other parameters should change accordingly .Is it possible ?
Thanks in advance.
5 Replies
Hi t-taaror,
I'm not 100% sure but i think thats what you want to do :
You have two tables (or more) with an identical shema (let say Table1 and Table2 as shown below)
1. Go to merge queries
2. Append Queries
3. Choose the tables you need to append
4. You shall obtain this result
If needed, you can add a column "origin" to Table1 and Table2 to know where each line in Append1 comes from (if you dont know how to do so just ask).
You can also append more than two tables, its not very different from what i explained there.
Hope this helps,
Regards,
Etienne
Hi Anonymous
I am using Direct Query and i don't Want to merge the tables into one table or one visual. Its like there is a set of visuals showing data from one server. I want to have a menu so that i can select the second sever and the parameters change automatically(Like Server Source Name, Database etc.). By doing this i need not to create different reports for each server.
