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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi h0hesc,

 

Try downloading the chiclet slicer custom filter from the marketplace in PBI Desktop - it should do the trick.

 

Br,

T

  • h0hesc's avatar
    h0hesc
    Frequent Visitor
    8 years ago

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      h0hesc,

       

      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

      • h0hesc's avatar
        h0hesc
        Frequent Visitor
        8 years ago

        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.