Forum Discussion

ineedyourhelp's avatar
ineedyourhelp
Frequent Visitor
6 years ago
Solved

select threshold value by a slicer

Please, help! We have a list of tasks [ID] that are solved at a certain percentage [% resolved], and we have 2 types of distribution of these tasks: 1) "without tolerance": if the task is s...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    ineedyourhelp ,

     

    You can create two columns, one column contains value "tolerance", without tolerance", another column contains column "solved", "not solved". Create hierarchy based on the two columns and drag the column with values "solved" and "not solved" to legend field of pie chart and create a slicer based on another column.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

ineedyourhelp ,

 

You can create two columns, one column contains value "tolerance", without tolerance", another column contains column "solved", "not solved". Create hierarchy based on the two columns and drag the column with values "solved" and "not solved" to legend field of pie chart and create a slicer based on another column.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.