Forum Discussion
Inverted Dates on Pie Chart
Hello everyone!
I am currently running into an issue when using a pie chart and slicer in Power BI. It seems like the values of my pie chart do not match up with the dates I select on the slicer. For example, if I filter it so that ony 2019-2022 is showing, it says there are not more items "on hold" If I look at my tables, this is not true as all the items on hold are from 2019-2022. Have you guys run into tis issue before? I'm adding screenshots to try to explain a bit better.
Hi, Anonymous ;
Since the date column in your data has blank values, if the filter is selected all, (2015-2022) contains blank values;
If filtered (2019-2022) blank values will be filtered out.I create a simple test.
IF select slicer.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
Since the date column in your data has blank values, if the filter is selected all, (2015-2022) contains blank values;
If filtered (2019-2022) blank values will be filtered out.I create a simple test.
IF select slicer.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.