Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

dynamically update pie chart based on user input

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

daynormalabnormal
110023
24577
347756
  • 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

     

    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.

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion

    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

     

    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.