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 employees. The result I want is a diagram showing 3 KPIs of the selected object.
To do this, I created a Hierachy Slicer to filter the objects that need to be calculated:
My slicer works fine if I create Measure to calculate each KPI value but it doesn't work when I create a new Data table to store KPI values, I don't know where the problem is, please help me.
9 Replies
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
I may not be reading this correctly but it sounds like you are trying to create a dynamic table based upon user interaction. This simply is not possible. Data tables are calculated only at the time of data load (refresh).
Hi Greg_Deckler, I just want to calculate based on the data loaded, every time Hierachy Slicer is selected, the value will change accordingly. I can do this on each Measure, but it doesn't work when I use a table to save the calculated KPI data.
