Dynamically changing X axis in a chart in a report based on RLS

[Optimusprime_25]

Hi Team,

We have a requirement where we have to implement dynamic X-axis in a chart. 

We have implemenetd RLS in the report on group. We have two groups basically ABC and XYZ.

When someone from ABC group logs in the report he should see different X axis and in the same report and same visual when user from other group XYZ logs in he should see different X axis in the chart.

Is there any way to implement this requirment.

Thanks in advance.

[Idrissshatila]

Hello @Optimusprime_25 ,

Try using field parameters and group both dimensions in one value and put the field parameter value on x-axis.

when its logged in with RLS it should filter to the dimension related to the person logged in.

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 so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin