Forum Discussion
How many Filter-tables?
Let go of the Excel mindset and embrace the concept of dimensions and facts. Your filter choice options could be stored in reference tables, implemented as calculation groups, or you could completely drop that idea and teach your users how to modify filters in Power BI.
d) None of the above. Use the standard filter pane. That's what it is there for.
Ok. Got it. In PowerBI I use the Filter-pane.
But before displaying in PowerBI:
If I have an Excel-Table as Source - with Tabs for Toggle, Single and multiple-Selection-Filters - what's the recommended way to structure them? Do I combine them into one tab, do I create a table for each type of Filter or do I create a table for each Filter itself.
Once I prepare them for display in PowerBI (...where I will use the Filter-pane): How do I handle the "empty cells" in Filter_multiple2?
Let go of the Excel mindset and embrace the concept of dimensions and facts. Your filter choice options could be stored in reference tables, implemented as calculation groups, or you could completely drop that idea and teach your users how to modify filters in Power BI.