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
Just try this way as below:
Step1:
Add a dim kpi type table, then use kpi type field in the bar visual
Step2:
Create another two measure as below:
numberpasskpi = SWITCH( SELECTEDVALUE('Table'[KPI Type]),
"KPI 1",[numberpasskpi1],
"KPI 2",[numberpasskpi2],
"KPI 3",[numberpasskpi3])totalkpi = SWITCH( SELECTEDVALUE('Table'[KPI Type]),
"KPI 1",[totalkpi1],
"KPI 2",[totalkpi2],
"KPI 3",[totalkpi3])Step3:
Then drag these two measure into visual
Result:
and here is sample pbix file, please try it.
Regards,
Lin
Dear v-lili6-msft ,
Thank you very much for your enthusiastic help, my problem has been resolved.