Power BI - Assignment 11

##filters ##tables ##dax

Somnath Banerjee Jul 05 2021 · 1 min read
Share this

Problem: 

Open the Excel file in the above folder and create a basic table showing data for sales of houses in different areas

There are 5 types of building - in an ideal world, each viewer should only see their relevant category.

I added a filter

There are two options available: create 5 independent reports or use one report but filter it to show data only for the current user. The latter can be performed using roles:

Create a role for each house type, filtering using the PropertyType code. Look in the Property types sheet to find the codes.

Once you have made the roles, check that each is working using View Roles on the Home tab:

Publish the report in Power BI Service and check the roles.

Comments
Read next