Forum Discussion

nimdy's avatar
nimdy
Frequent Visitor
5 years ago
Solved

Dropdown slicer with title inside

Is it possible using standard or custom visuals to show a dropdown slicer title inside the dropdown? Company design standards dictate I have dropdowns at the top of my reports. I have a text box with...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi nimdy 

    I think you want to change the place of slicer header to reduce space.

    Your demand is a good idea, while it is not supported to implement in Power BI currently.

    You can vote up this idea for this function : Header in slicer selection controls instead of above slicer

    Or you can achieve your goal by using measure to build a card visual and group card and slicer.

    Firstly build a slicer and trun of the slicer header.

    Measure:

    Measure = 
Var _T = VALUES('Table'[Country])
Var _Count = COUNTROWS(_T)
return
IF(ISFILTERED('Table'[Country]),IF(_Count = 1,MAX('Table'[Country]),"Multiple selections"),"Country")

    Drag card visual to a suitable postion and Group two visuals. Rsult is as below.

    By default:

    Select A:

    Select Multiple selections:

    You can download the pbix file from this link: Dropdown slicer with title inside

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi nimdy,

 

I am not aware of any visuals that might offer you exactly what you need (the image did help to understand, thanks).

 

However, you could try something like this, which will help you gain space horizontally:

For that, you just need to (1) delete your text box, (2) use the standard Slicer visual and (3) tick the Slicer Header to on.

 

Have a nice day,

Thomas

nimdy's avatar
nimdy
Frequent Visitor
5 years ago

Thanks. We used to have titles / slicer headers on the visuals, but the new corporate design means our title bar is very narrow, so titles can only go to the left of the visual. 

 

I had a try of xViz Hierarchy Slicer visual, which allows me to put the title inside the visual, but when I reduce the height of the visual the dropdown doesnt work. It seems only the default dropdown slicer allows the dropdown to work regardless of the visual size (again, image below to explain what I mean): 

 

https://imgur.com/kkCeZ6U

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi nimdy 

    I think you want to change the place of slicer header to reduce space.

    Your demand is a good idea, while it is not supported to implement in Power BI currently.

    You can vote up this idea for this function : Header in slicer selection controls instead of above slicer

    Or you can achieve your goal by using measure to build a card visual and group card and slicer.

    Firstly build a slicer and trun of the slicer header.

    Measure:

    Measure = 
Var _T = VALUES('Table'[Country])
Var _Count = COUNTROWS(_T)
return
IF(ISFILTERED('Table'[Country]),IF(_Count = 1,MAX('Table'[Country]),"Multiple selections"),"Country")

    Drag card visual to a suitable postion and Group two visuals. Rsult is as below.

    By default:

    Select A:

    Select Multiple selections:

    You can download the pbix file from this link: Dropdown slicer with title inside

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.