Forum Discussion
Visual Filters (Text boxes or similar) in Power BI
Hello,
I am looking for a way to use visual filters rather than a slicer:
Let's say I have a company with four departments (Sales, Marketing, Production, HR). I show different data for the departments over time on a bar chart. This works fine. Now I want to filter the bar chart depending on the department. I could insert a Slicer and by klicking on "Sales" I only see the Sales data in the chart. But I would like a visual filter, like creating a text box with "Sales" and by klicking on it the graph adjust. Is there a way to do this or a workaround?
This is a simplified version of my problem. I have a lot of different filter options, this is why a slicer gets unclear and a visualization in different boxes would help alot.
Best,
Daniel
I'll see what I can do! I'll make another more detailed mockup and try to share it with you
*Edit; A quick and dirty example report
mockup found here: https://file.io/FLG5z3
Here are some basics:
I've highlighted/colored the important bits
Chiclet slicer interaction:
Chiclet interactionsTable interactions:
table interactions
Bar chart interactions:
Bar chart interactions
Creating "lists" with certain subdepartments using visual level filter in the visualization filters:
visual level filters
You could also use the bar chart to filter what subdepartments use what kind of budgeting method by clikcing on the bar (second page of the mockup report):
filter with bar chart
Br,
T
10 Replies
Hi h0hesc,
Try downloading the chiclet slicer custom filter from the marketplace in PBI Desktop - it should do the trick.
Br,
T
Anonymous: Thank you! It gets me closer to what i want but not quiet close enough :) I like the picture option and the different columns that can be selected. However, the number of columns is always the same, which doesn't work for my case. Example:
I have a Sales department with 8 sub-departments that are included in my filter list (which should be shown in one row)
Next, I have the Markting department which has only 3 sub-departments that are included in my filter list (which again should be shown in one row) and so one. Is there a way to do this?
Edit: Maybe something easier that would also help me: Is there a way to manually change the order of the filtered items, i.e. instead of ascending alphabetical order rather manually change the order?
Im not sure about the order, but if you have lots of "boxes" you could try having several chiclet slicers in one report - one for every department. This doesn't completely solve your issue but gets you a bit closer!
Br,
T
