Forum Discussion
How to drill through rows in a range
- 3 years ago
Hi , Anonymous
According to your description, you want to filter the [Project Number] in a slicer and you want to select one row to jump to another page to show all the data who contains the [Master Document] in pre-Page.
In my thought , first you slicer [Project Number] in first page ,like this:
The [Master Document] has "MD1,13,4" , so in the Page2 will show all the data who contains "MD1,13,4":
If this , here are the steps you can refer to :
(1)This is my test data:(2)First , we need add a calculated column in this table :
Column = 1Then we need to click "New Table" to add a calculated table as a assited slicer:
Table = VALUES('Document'[Project Number])(3)Then we need to put the 'Document'[Project Number] and the 'Table'[Project Number] as a slicer in the first Page1:
We need to put the [Column] in Table visual.And you need to select "Don't Summarize" for this field both in Page1 and Page2:
And then we need to open the Sync slicer for the 'Table'[Project Number] to Page2 and create the same group for three slicers:
(4)Then we can create a measure for Page2 and configure it:
Measure = var _slicer = VALUES('Table'[Project Number]) var _t = SELECTCOLUMNS( FILTER(ALLSELECTED('Document') , 'Document'[Project Number] in _slicer) , "docu" , [Master Document]) return IF( MAX('Document'[Master Document]) in _t ,1,0)Also you need to put the [Column] field on the "Drill through":
Also , you can close the "Text wrap" in Table visual and then you can drag your mouse to hide this [Column].
Above all , you can meet your need if i did not misunderstand your description. You can also download my test .pbix to test.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , Anonymous
According to your description, you want to filter the [Project Number] in a slicer and you want to select one row to jump to another page to show all the data who contains the [Master Document] in pre-Page.
In my thought , first you slicer [Project Number] in first page ,like this:
The [Master Document] has "MD1,13,4" , so in the Page2 will show all the data who contains "MD1,13,4":
If this , here are the steps you can refer to :
(1)This is my test data:
(2)First , we need add a calculated column in this table :
Column = 1
Then we need to click "New Table" to add a calculated table as a assited slicer:
Table = VALUES('Document'[Project Number])
(3)Then we need to put the 'Document'[Project Number] and the 'Table'[Project Number] as a slicer in the first Page1:
We need to put the [Column] in Table visual.And you need to select "Don't Summarize" for this field both in Page1 and Page2:
And then we need to open the Sync slicer for the 'Table'[Project Number] to Page2 and create the same group for three slicers:
(4)Then we can create a measure for Page2 and configure it:
Measure = var _slicer = VALUES('Table'[Project Number])
var _t = SELECTCOLUMNS( FILTER(ALLSELECTED('Document') , 'Document'[Project Number] in _slicer) , "docu" , [Master Document])
return
IF( MAX('Document'[Master Document]) in _t ,1,0)
Also you need to put the [Column] field on the "Drill through":
Also , you can close the "Text wrap" in Table visual and then you can drag your mouse to hide this [Column].
Above all , you can meet your need if i did not misunderstand your description. You can also download my test .pbix to test.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Anonymous3 years agoNot applicable
Thank you so much for your detailed solution!