Report Server Web Portal KPI's based logged in user

[SSWADOOD]

Can we display kpi's on reports server webportal based on loggedin users??

i have created the dataset and ran it on reportbuilder and applied users!userid filter to it 

at first it was not showing me anything as my userid was not in the data set, after i added  my userid to the dataset it was showing data 

but it also showed the same data to other other logged in users who had different data against their userid's

Thanks.

[v-xiaoyan-msft · Accepted solution]

Hi @SSWADOOD ,

A KPI will only use the first row of data from a shared dataset. Make sure that the data you want to use is located on that first row. To create a shared dataset, you can use either Report Builder or SQL Server Data Tools.

For more you can refer to Working with KPIs in Reporting Services 

Best Regards,
Community Support Team _ Caitlyn

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