Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Everyone!
I have a table Document, and I want to set up a slicer by Project Number that shows me in table related content by another column. Let me explain this by this example:
Here we have column Document Cut = O-4720-J-5022.
When I select Project number slicer CP-20-3006 it is neccessary to show not only Document Numbers that related to this CP-20-3006, but also need to show all document numbers which have the same value in Document Cut. So all this Project Number values have the same Document Cut.
I understand that in this case probably we should filter by Document Cut number, but It's important to filter by Project Number and see the related content.
Is there any options how it can be realised?
Appreciate for any help!
Solved! Go to Solution.
Hi @Nurzh_17
First create a slicer table for project number
Projects =
ALLNOBLANKROW ( 'Table'[Project Number] )
Then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter.
FilterMeasure =
VAR SelectedProjects =
VALUES ( Projects[Project Number] )
VAR DocumentCuts =
CALCULATETABLE (
VALUES ( 'Table'[Document cut] ),
'Table'[Project Number] IN SelectedProjects,
ALL ( 'Table' )
)
RETURN
COUNTROWS ( FILTER ( 'Table', 'Table'[Cocument cut] IN DocumentCuts ) )
Hi @Nurzh_17
First create a slicer table for project number
Projects =
ALLNOBLANKROW ( 'Table'[Project Number] )
Then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter.
FilterMeasure =
VAR SelectedProjects =
VALUES ( Projects[Project Number] )
VAR DocumentCuts =
CALCULATETABLE (
VALUES ( 'Table'[Document cut] ),
'Table'[Project Number] IN SelectedProjects,
ALL ( 'Table' )
)
RETURN
COUNTROWS ( FILTER ( 'Table', 'Table'[Cocument cut] IN DocumentCuts ) )
Hi @tamerj1
Thank you so much for your feedback! It works for me.
Sorry to bother, there is another case on this table, could you please advise? 🙂
CASE EXAMPLE:
Here I filtered Project Number = CP-22-3145 and get all related columns.
And I want to show via drill through Drawing Number, Project Number, Master Document columns on another table where values related to ALL Master Document values.
Expected result will be(I filtered it manually by taking all Master Document values from previos screen):
You can see here that this table includes not only CP-22-3145, but all Project Numbers and Drawing Numbers that have the same Master Document.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |