How to filter the Pie Chart with Date

[Ibrahim_shaik]

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.

[v-yiruan-msft · Accepted solution]

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

[lbendlin]

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.