cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eddydm Member
Member

Can we use a scripting language in PowerBI?

I'v a power-bi-file with different reports included. On many pages I'v used a slicer to get the user the opportunity to select the department.

 

Now I would like that on my first page the user selects his department he want to see in the other pages and that the power-bi-program adjust every slicer (concerning departments) on all pages.

For start, I would like that this action happens only at the moment the user opens the power-bi-file.

I agree that I (as 'devellopper') has to tell to power-bi which slicer he has to adjust and to which value.

 

Is this also possible when the report is published?

 

I know that this could be achieved by RowLevelSecurity but

* at that moment the user can't see any data of other departments (and even no data about the total of all the departments, or mean-value, ...)

* design of pbix-file has to be adapted

* licence-model for the end-user is not clear to me at this moment.

 

Kind regards.

Thanks in advance for any ideas.

 

 

Eddy

 

4 REPLIES 4
Super User
Super User

Re: Can we use a scripting language in PowerBI?

If you need filter multiple pages, you need to use Report level filters, not slicers.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


eddydm Member
Member

Re: Can we use a scripting language in PowerBI?

@Greg_Deckler Thanks for your respons! I don't see any visualisation technique for such a report filter.

In my opinion the interface of those report filters is not for basic- users!

Any idea?

 

Second problem is that in my case I have different datasets (from different sources) all with an indication of department, but the fieldnames are different. So the users has the impression that there is only one field 'department' but there are different fields (one in each dataset). I'm afraid that I shall have to redesign.

Super User
Super User

Re: Can we use a scripting language in PowerBI?

Sounds like you would want to create a table of just your Departments and then relate all of your various department columns to that table, then you would be able to use your central Department table for all of your filtering.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Can we use a scripting language in PowerBI?

Hi @eddydm,



It is not possible to use Slicers to apply to all pages in a report currently. You can vote the idea here.Smiley Happy

 

Regards