edit parameter / slicer

[Anonymous]

Hello,

I did a dashboard to see the server Status, Jobs that have succeeded or failed and so on.

This dashboard is very popular.

My client asked me to do the same dashboard but for two other servers.

I have added two parameters to the actual dashboard, the Servers list and the Data base list.

The preliminary tests show that it is working.

So, I wonder if there is a way to relate a slicer to a parameter.  For example, if we select server a from the slicer, it does the same action as edit parameter and select server A.

If it is not possible, when a dashboard is published on the portal, it is possible to goes into setting, then parameters and select the server and the database.  The difficulty arises from the fact that we see only the default value not a drop-down list.  It is why I thought using a slicer.

Does someone as an idea or to switch between servers in a simple way?

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Edit parameter in Power BI Service is available for users who have edit permission to the dataset,it needs you to go to dataset setting and change the parameter.

Please see more details here:

https://docs.microsoft.com/en-us/power-bi/service-parameters

there are some limitation for editing parameter in power bi service, 

it should be not parameters that restrict the available data, but parameters that define and describe acceptable values.

also, it may only work for import mode.

Another way, if 'Servers list and the Data base list" are from two different data source, could you import them together in the data model in power bi desktop, then it would be possible to use the different selection in a slicer.

Best Regards
Maggie

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

[Anonymous]

Hello Maggie,

When edit parameters, I have to select the server Name and the Database Name then I click on ok.

Then I need to click on Apply Changes and the information is updated, at least in Power BI Desktop.

For some reasons, I don't know, I am able to use the edit parameters in Power BI Services but the data does not seem to refresh. 

Also, In Power BI services, when you go to dataset, then in parameters, there is no dropdown list.  The End-user need to provide the Server Name. It is not friendly user.

For those reasons, I might be interested by your second option.

So, imagine that I have two servers and two database ex: Server A and EDW, Server B and EDW_2, could you provide me the steps to add those two data sources in Power BI and especially how can I use a slicer to switch between the two data sources to have the data set updated.  Please note that if we select Server A defacto the database will be EDW and if we select the server B, the database will be EDW_2.

Thank in advance for your help.