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.


I have book! Learn Power BI from Packt


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.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 913 guests
Please welcome our newest community members: