Forum Discussion
Visual Filters (Text boxes or similar) in Power BI
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
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
Anonymous several chiclet slicers would also work. However, in the end I have one bar chart, that gets adjusted according to what is filtered. Does it work if I have several chiclet slicers that all refer to the one bar chart? And if yes, how do I set up these different slicers if I have only one column "departments" where all the departments are listed, but the slicer should only show let say the sales departments.
To fuly understand your situation, can you send me a pic of what you are working with and what you would like to get done?
I'm pretty sure this could be done with chiclet slicers, buttons and bookmarks.
For instance, I use several chiclets when I want to filter years->quarters->months. I have a separate slicer for each and e.g. if I select year 2018 it doesn't show all months/quarters in the other chiclets because they are in the future. All of these chiclets do however filter a line chart that I have.
Br,
T
Anonymous thank you for your answer. I made a simplified version of my problem:
This is what the dashboard should look like:
Here I would like to filter by clicking on the subdepartments like Sales Soccer and by this the bar chart on the right hand side would only show "Incremental" as 100% as Current and Last would show 100% in "Incremental" as well.
This is what the input looks like:
The bar chart works fine. But so far I only have one large Chiclet Slicer that includes all the 14 subdepartments in alphabetical order. But I would like to split the Slicer into several that only include the subdepartments of one department just to make it easier to understand and filter.
Is there any way to do this?
Best