Forum Discussion

h0hesc's avatar
h0hesc
Frequent Visitor
8 years ago
Solved

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 depar...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    h0hesc,

     

    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 interactions

     

     

     

     

     

     

     

     

    Table 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

h0hesc's avatar
h0hesc
Frequent Visitor
8 years ago

Anonymous: Thank you that looks great. The recommended version is was i am looking for. My priority is only filtering subdepartments (if filtering by departments is also possible, that would be even better). 

But how can I create this filter of yours, with departments on as ChicletSlicer on top with departments and then a list with the subdepartments below it? I don't quite understand how to do these independent filters. If I create multiple filters and try to prefilter them (like showing only controlling subdepartments in one filter and only marketing subdepartments in another filter) that doesn't work.

Is it possible to upload this power bi document?

 

*Edit: and one more question: Is it possible to seperate the slicer as well? In my original file I have more than 3 departments (I have 10) and with 10 I can put all of them in one row and list the subdepartments below

Anonymous's avatar
Anonymous
Not applicable
8 years ago

h0hesc,

 

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 interactions

 

 

 

 

 

 

 

 

Table 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

  • h0hesc's avatar
    h0hesc
    Frequent Visitor
    8 years ago

    Anonymous: Perfect, thank you very much. It worked like I want it to :D