dynamically update pie chart based on user input

[Anonymous]

I have data mentioned below in the table I would like to dynamically update pie chart whenever user inputs day field

day	normal	abnormal
1	100	23
2	45	77
3	477	56

[Nathaniel_C · Accepted solution]

Hi @Anonymous , if I understand your question, please see the picture below. You will see your table, a pie chart and a slicer.  Put the abnormal/normal columns on the pie chart by clicking on the pie chart symbol and adding the two columns.  Next click on the slicer symbol and add the day column to that.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Vishu_2190 · Accepted solution]

1. Create a pie chart
2. Add a slicer to the report.
3. Connect the slicer to the category dimension.

You can also use the filter function to filter the pie chart based on user input.

[Nathaniel_C · Accepted solution]

Hi @Anonymous , if I understand your question, please see the picture below. You will see your table, a pie chart and a slicer.  Put the abnormal/normal columns on the pie chart by clicking on the pie chart symbol and adding the two columns.  Next click on the slicer symbol and add the day column to that.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel