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 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou