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
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
I came up with a quick mockup, however, could you clarify are you going to filter based on subdepartments or just departments?
I made two mockups (separated by a cyan line). The top most filter filters the bar charts for both mockups
In the first one you have a chiclet slicer with departments and then another one with subdepartments that get filtered when a department is chosen.
In the second one I have all subdepartments on their own. The extra filters in the second mockup are just to get the contenct of the subdepartment slicers cprrect - they do not filter anything else and can be hidden from users.
I would recommend having the sub-departments as a table e.g. beneath the chiclet slicer, but separate chiclets just showing the subdepartments work fine as well, just make sure end users aren't tempted to try and filter with these subdepartments.
Recommendationmockups filter2 mockups
I did need to unpivot your data in order to create the bar chart (columns current and last) but other than that, this isn't anything more than playing around with filters and interactions between visuals.
Hope this helped a little!
Br,
T