Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NNaj
Helper IV
Helper IV

Visibility of entries on PowerBI Report Builder

Hi All,

 

I have recently downloaded report builder and have connected it to my PowerBI Data. I need to generate a report for each company ID, as shown below:

 

report builder q.png

 I did this by changing the visibility to the expression 

 

=IIf(Fields!CODE.Value = "COMPANY3", false, true)

 

This part is fine because I just want to hide the code but show the data for the rest of the companies.

 

My question is:

 

Is there an easy way to generate this table for company 1 without having to manually change this expression every time?

 

If I want the same report for company 1, is it possible to have a selection tool where I select company 1 and then get the same table but only where company 1's name shows.

 

Thank you for your help

2 REPLIES 2
bradsy
Employee
Employee

You can add a parameter that has the list of companies, then change your expression to something like: =IIf(Fields!CODE.Value == Parameters!CodeName.Value, false, true)

Anonymous
Not applicable

Were you able to sort this out? If yes, Please me out!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.