Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dear v-lili6-msft,

    Can you please explain with an example.

    This is the output I want to display:

     

    sample pbix file 

     

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Dear v-lili6-msft ,

        Thank you very much for your enthusiastic help, my problem has been resolved.