Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table with all products and its compononents at my company, for example:
FATHER_PRODUCT | SON_COMPONENT |
XXX | X-1 |
XXX | X-2 |
XXX | X-3 |
XXX | X-4 |
X-4 | X-41 |
X-4 | X-42 |
X-4 | X-43 |
X-3 | X-31 |
X-3 | X-32 |
X-3 | X-33 |
The FATHER_PRODUCT column has the name of the product and the SON_COMPONENT column has the name of the componentes used on the product, and as you can see in this example there are some components that are also a FATHER_PRODUCT with other components and so on.
What I am trying to do is when I select a row of this table I would like to go to another page and use the SON_COMPONENT selected as the FATHER_PRODUCT... is it possible?
example: suppose user select the row 4, I want to create a button where the user goes to another page with another table as shown:
I tried several ways, but wasn't able to achieve it yet...
Solved! Go to Solution.
Hi, @Anonymous
Steps.
1. Create a copy of the table (Table 2), create the calculation table: Table 2 = Table 1
2. Create a new target page and create a visual with the fields of table 2
3. Drag and drop the fields from the original table (Table 1) into the drill-through section of the target page
4. Create the following measures and filter the items in the filter pane of the target page for measures equal to 1
_selectedSON =
SELECTEDVALUE('Table'[SON_COMPONENT])
isShow = IF(SELECTEDVALUE('Table 2'[FATHER_PRODUCT])=[_selectedSON],1,0)
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Steps.
1. Create a copy of the table (Table 2), create the calculation table: Table 2 = Table 1
2. Create a new target page and create a visual with the fields of table 2
3. Drag and drop the fields from the original table (Table 1) into the drill-through section of the target page
4. Create the following measures and filter the items in the filter pane of the target page for measures equal to 1
_selectedSON =
SELECTEDVALUE('Table'[SON_COMPONENT])
isShow = IF(SELECTEDVALUE('Table 2'[FATHER_PRODUCT])=[_selectedSON],1,0)
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not directly. Drillthrough does not (yet) allow cloumn transitions. You'd have to use a measure on the drillthrough target page to accomplish some of that.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |