Forum Discussion
Data filtering problem with slicer
Hi everyone, I have a data table: I need to perform KPI for Organization, Team and every employee, KPI of Team is the data of the employees in the team, KPI of Organization is the data of all...
Hi v-lili6-msft ,
I know that with measure I can filter data by slicer, but the problem is how to display 3 values 'Number of Pass', 'Number of Fail' and 'Total' for each KPI as I wish.
With Measure list, I can only display them as adjacent columns:
v-lili6-msft
Community Support
Community Supporthi Anonymous
You need to keep a Kpi type into axis in the visual, here is a similar post for you refer to:
https://community.powerbi.com/t5/Desktop/Dynamic-average-on-X-axis-of-a-bar-chart/td-p/1083576
If you still have the problem, please share your sample pbix file and your expected output.
Regards,
Lin