Matrix Table -onclick alternative

[Daniel2102]

Hi there, lets say i have 2 matrix table i needed to display in a single page . what i wanted is for table 2 (table 2 is for more details)to only appear when i clicked on a value in table 1 (table 1 is taking up the whole page). any ideas how i can get this 2 work? i know there is drill through where we right click it but most of our users are not experience with PBI which is why is not a good experience for them expecially new users.

Another idea i have is to create a button for it to only show when i clicked on table 1's value using bookmark but that would required the user to know to click on the button after selecting the value. however i wanted to hear from the experts here is there any other alternative ways? is there another visuals i can use? 

EDIT:

Adding on some sample pic and another concern.

Pretend that table 1 take up the whole grey background and table 2 is at the back not visible

i wanted it to appear only when i click on table 1 value and close either via a button or table 1 or any other suggestion that you all have.


Not sure if i should create another discussion for below but this will only be relevant if the above problem can be solved otherwise is just waste of effort (but good to know for future use)

another issue i just realize is that after i click table 1 then table 2 will show the details, but if i select any value at table 2 it will reset table 2 and it will show me the value i clicked at table 1 this time. i didn't want Table 2 to change no matter what the user does. 

i did found one from the discussion here https://community.fabric.microsoft.com/t5/Desktop/showing-more-details-when-user-click-on-some-value... . they used card to block any selection of the table but here is my issue...i needed to scroll.

Thanks

[isjoycewang]

If the visibility of Table2 depends on the selection of Table1, you may consider some steps as below:

1. Define the selected status: 

- create measure1 to check if Table1 selected or not, the measure depends on fields of Table1
- Some useful fx: SELECTEDVALUE, COUNTROWS, ISFILTERED, HASONEVALUE...

2. Define the Table2 visibility by measure1

- you can use a card/shape cover on Table2 or change the font color of Table2

- create measure2 to define when the color is transparent (#FFFFFF00) and apply it to the cover background or font color
- Example: IF( measure1 = TRUE(), "#FFFFFF00", "White")

By this way, you can control the visibility by the selected status of Table1.

Helpful article for reference: Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI

[Daniel2102]

Hi isjoycewang,

this feels kinda close..would you able to provide a sample?  based on the reference you provided when i try the table seems to only work if is side by side and not overlap. it still wont appear when i click on table 1 .

[Idrissshatila]

Hello @Daniel2102 ,

you could use field parameters which you can group many fields in one parameter and could add more fields to the table through a slicer.

in this case, the user can modify what he want to see.

check it out https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Daniel2102]

Hi Idrissshatila

Thanks for the quick response, unless im wrong but this seems to work only if there is a slicer.

[Idrissshatila]

Hello @Daniel2102 ,

true, they would use a slicer to pick the columns they want to see in the visual, which make it easier for them to build what they want to see.