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

Question

Hi Team,&nbsp;We have a requirement where we have to implement dynamic X-axis in a chart.&nbsp;&nbsp;We have implemenetd RLS in the report on group. We have two groups basically ABC and XYZ.&nbsp;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.&nbsp;Is there any way to implement this requirment.&nbsp;Thanks in advance.

idrissshatila · Answer

Hello&nbsp;Optimusprime_25&nbsp;,&nbsp;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.&nbsp;https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters&nbsp;If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos&nbsp;👍&nbsp;Follow me on Linkedin

Forum Discussion

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

1 Reply

Related content

Dynamic Report Subscription

Power BI - Dynamically Change Column Name

Change report background color dynamically

Paginated report dynamic subscription including indirect reports

Dynamic change Ranking based on Dimension change