Very good breakdown of all the filter options. Only missed option would be to apply the filter at the query level. Not always recommended but if the end users are absolutely sure they only want those countries then reduce the data set and move forward from there.
Great question! This is actually a topic I plan to bring up in a future video. But basically, they're extremely similar. The New Slicer *probably* has a little bit more functionality than the chiclet slicer, but at the end of the day they accomplish the same goal. The chiclet slicer was so popular of a 3rd party visualization that Microsoft made their own version to be included in the out-of-the-box version of Power BI!
![💡 What is the Power Query Editor? [Excel to Power BI Series - Ep. 1]](http://i.ytimg.com/vi/mMGXAS4kB90/mqdefault.jpg)
![[ ออกกอง ] วัยหนุ่ม 2544 โลกหลังลูกกรง..ทัวร์กองถ่ายหนังใน "คุกของจริง" | JUSTดูIT.](http://i.ytimg.com/vi/vB--aOkZCpw/mqdefault.jpg)
Very good breakdown of all the filter options. Only missed option would be to apply the filter at the query level. Not always recommended but if the end users are absolutely sure they only want those countries then reduce the data set and move forward from there.
Great presentation skills! Thank you!
Isn't clicking on another visualisation with cross filter enabled not also a type of filter?
Interesting stuff, thank you
You are missing calculation groups filtering. Beside of that - nice presentation.
How is Chiclet Slicer better than New Slicer?
Same question i had because if I'm correct it seemed to have almost the same options as the new slicer😅
Great question! This is actually a topic I plan to bring up in a future video. But basically, they're extremely similar. The New Slicer *probably* has a little bit more functionality than the chiclet slicer, but at the end of the day they accomplish the same goal.
The chiclet slicer was so popular of a 3rd party visualization that Microsoft made their own version to be included in the out-of-the-box version of Power BI!