Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hyperlink Filter Parameter Bypassing Edit Interactions

Hello everyone,

 

This is my first post and it may be a bit wordy,

 

I have a report that has an overview tab for acct mgrs, with rankings and aggregated totals. The rest of the report are detailed views of line level data for each acct mgr. The overview tab, as well as the remainder of the report, has a synced slicer for selecting acct mgrs. The Acct Mgr slicer drives all visuals for the exception of a few tables, which I use to display the aggregated totals/rankings for the acct mgrs, so they can compare themselves to their peers. From the "Edit Interactions", I have selected "None" to ensure the Acct Mgr slicer does not affect my table aggregations for all acct mgrs.

 

What we have done previously was use hyperlinks and embed it in our CRM software (for ease of use and no access to hyperlink), and each Mgr can go to their filtered report. We don't want anyone seeing line data of other acct mgrs. This has worked for us in other reports, but not this one. 

 

Using the hyperlink "overrides" my Edit Interactions, or bypasses it. It's like the hyperlink filters the data down before it's given to the report. Using the hyperlink removes my data from my other acct mgrs, which debunks my aggregations and rankings.

 

Is there a better way about going through this?

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support

    Hi Anonymous ,

    I'm not sure that I understand what you want. You used hyperlinks but they affected your data. And you want each mgrs to view their own reports not the content of others. So you need another way to implement it. Right? If so, maybe you could try RLS ( row-level-security). For more details, please view the following links.

    Row-level security (RLS) with Power BI 

    Power BI Row-Level Security And Where To Filter

     

    If I misunderstand, please share a few pics of what you want. 

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support

    Hi Anonymous ,

    Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.