Show data from different tables in a drill through page based on a slicer selection from main page

[jithinrg]

Team,

I have a data model with 3 tables: 

1 master, 2 fact tables (star schema)

Data model -> 1 to * from master to both fact tables (single direction) connected via employee id in all three tables.

There are 3 pages in the report.

Main page show a summary of all employees with their sales details (it's a leadership view) table with some slicers.

Second page is the individual details page (like a employee portfolio) of each employees based on slicer selection or RLS.

Third page is a detailed view (drill thorugh) of 2nd page with tables having more columns.

Scenario:

****************

There is a slicer in 2nd page which is having "Yes" / "No" option. (also in main page)

If we select "Yes", we have to display a table visual with some columns from 1 fact table and a measure value (which is sum of sales value)

If "No", display another table visual with some columns from 2nd fact table and a measure value (which is sum of sales value).

Do not show both tables in the page. It should display based on the slicer value we selected.

To summarize, employee details are present in both fact tables. Based on the slicer selection we have to show data from the respective fact tables.

Also it would be great if we select the slicer from main page and drill through page also show the above requirement.

[amitchandak]

@jithinrg , I think you need conditional drill through, Video from Guy in a cube

https://www.youtube.com/watch?v=4Qy-bksqExI

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

[jithinrg]

Thanks @amitchandak . The video shows navigation to different pages.

My scenario is to show tables based on the slicer selection in same page (or slicer selection from the main page.)

like bookmarking...if the slicer selection is yes, show this table, else another table..is it possible?

[Hariharan_R]

Hi @jithinrg 

for your scenario Yes / No button with bookmark is good. 

Ref - https://www.aerieconsulting.com/blog/how-to-hide-and-show-visuals-in-power-bi

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin