Forum Discussion

Daniel2102's avatar
Daniel2102
Regular Visitor
2 years ago

Matrix Table -onclick alternative

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 ...
Need Help
Tips and Tricks
isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

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's avatar
    Daniel2102
    Regular Visitor
    2 years ago

    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 .