Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Helper V
2 years ago
Solved

How to filter the Pie Chart with Date

Hi Power BI Community,

 

I have a table that has date, time column and num1, num2 columns are integer column.

 

I have added the num1, num2 columns in the values Field of the Pie Chart.

 

I want to filter the Pie Chart with the Date Slicer and I want to show the per day sum values of both the columns in the Pie Chart.

 

I added the date column in the legend and it didn't work, although I can Filter the Pie Chart from the "Filters on the Visual Pane" on the right.

 

I want to do with the Date Slicer.

Like this it should show if select a Date in Date Slicer it should filter accordingly.

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Ibrahim_shaik ,

    You can create a slicer and apply the field [Date] on it. The pie chart will be filterd dynamically base on the slicer selections since the field [Date] and [num1],[num2] are from the same one table. You can find the details in the attachment.

    Best Regards

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    I want to filter the Pie Chart

    Design red flag. You are most likely using the wrong chart type for the message you want to convey.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ibrahim_shaik ,

    You can create a slicer and apply the field [Date] on it. The pie chart will be filterd dynamically base on the slicer selections since the field [Date] and [num1],[num2] are from the same one table. You can find the details in the attachment.

    Best Regards