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 Anonymous
you should know that:
- Calculation column/table not support dynamic changed based on filter or slicer.
- Measure can be affected by filter/slicer, so you can use it to get dynamic summary in the visual.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Regards,
Lin
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:
hi 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