URGENT HELP Regarding dynamic columns display in powerbi

[Sudais22]

Good day everyone, 

Sudais here, Im fairly new to powerbi and working on some simple task. I was required to create a interactive report for users. So my manager required me to create button/ slicer tile where when user press the column in the matrix show/hide based on that. I tried to use bookamrks but i need to implement RLS later. I also tried to use filters, blanks all but unfortunately nth help jus to update. 

Matrix

Rows: Category, Entity email, Grade Email

Columns: nill

Values: nill

Here Grade email the one need to update dynamically also there are no null values 

1 entity email might have multiple grade email. 

Thank you

[v-shex-msft]

Hi @Sudais22 ,

Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

This here is a forum where users help users, time permitting.  For urgent requests contact a Microsoft partner near you.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...