Show columns of a table based on another table field selection

[Anonymous]

Hello everyone,

I would like to know whether there's the possibility to show a number of columns of a merged table based on another table field selection.

Please find attached the sample .pbix file: PBIX Download Link 

I have the INDICATORI table linked with MergedQuery through the indicatore field. The merged table will show null values related to the indicatore field contained in the INDICATORI table.

What I would like to achieve is that, if I select in a report Indicatore 1, merged table report will have to show the following columns:

1. Indicatore
2. Numeratore
3. Denominatore
4. Colonna Indicatore A

If i select in the same report Indicatore 2, merged table will have to show the following columns:

1. Indicatore
2. Numeratore
3. Denominatore
4. Colonna Indicatore B
5. Colonna 2 Indicatore B

[Syndicate_Admin]

You can't. It's not a perfect solution but I think that there is no way to chage the columns of a table with a drill through.

Using indicator 1 table and indicator 2 table as page names may help the users to select the correct option.

[Syndicate_Admin]

With buttons and bookmarks you can also do this in 2 different pages.

If drill though is a must you can create 2 hidden pages, one for Indicator 1 table and other one for the indicator 2 table, and selecting the corresponding one when using the drill through.

[Anonymous]

@Syndicate_Admin how can i set it that, if user select indicator 1, it'll go in page 2, and if he selects indicator 2, it'll go in page 3?

[Syndicate_Admin]

You could use a bookmark:

- First, create 2 buttons one for Indicator 1 and other for indicator 2

- Then, create 2 tables, one over the other with the columns you need

- After that create 2 bookmarks, one that shows the table for the indicator 1 and hides table of the indicator 2 (boomark 1) and other that shows the table for the indicator 2 and hides table of the indicator 1 (boomark 2)

- Finaly, asign each boomrk to the buttons.

[Anonymous]

Thanks @Syndicate_Admin , I forgot to mention that the filter action must be made with drill through and that indicator selection and table result are in two different pages.

Any hints?