How to Display Slicers Horizontally

[Jalalk]

Hi Team,

I have recently installed new desktop version of Power Bi desktop. I am trying to display slicers horizantally but unable to find the options in the new version. Below is the slicer and when i go in visual options i cannot find the Horizontal option to display. 

[Padycosmos · Accepted solution]

In the latest version, the slicer settings have undergone a change. From the slicer settings options, please select the Tile option as shown in the image above. You would get a vetically oriented slicer slicer which you can resize into a horizontal one. It works

[Priya1969 · Accepted solution]

Please refer this link. 

Power BI December 2022 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

[Padycosmos]

Please watch my video in the link below:

https://www.youtube.com/watch?v=-C2TwItozHw 

[Jalalk]

I had seen your video and its not working for me. I dont get an orientation options to change from vertical to horizontal.

[Padycosmos · Accepted solution]

In the latest version, the slicer settings have undergone a change. From the slicer settings options, please select the Tile option as shown in the image above. You would get a vetically oriented slicer slicer which you can resize into a horizontal one. It works

[adubry75]

The problem here is that if you resize that Tile visual into a square so that the tiles are 2x2, Power BI puts 2018 in the first column, then 2019 BELOW 2018, and then 2020 in the top second column and 2021 BELOW 2020.

Preferrably it should be 2018 and 2019 in the first ROW, then 2020 and 2021 in the second ROW. I can't seem to find a way to do that with Tiles. Thanks!

[Padycosmos]

Hello

Select the new slicer shown in the screenshot

Format Slicer settings as shown below

The result is as below:

Hope this helps

[adubry75]

Thanks. My Power BI Desktop (Version: 2.124.1960.0 64-bit (January 2024)) does not have that slicer visual. I tried to upgrade but we're not allowed to at my work until the Report Server ALSO gets upgraded next month so I gotta wait :). Hopefully when I get the update that visual will be available, thanks!

[Roopesh_Kumar]

Thanks for the solution, Is there a way to get the slicer "vertical list" to be in horizontal?, instead of converting them to tiles?

[Padycosmos]

Hello

Select the new slicer shown in the screenshot

Format Slicer settings as shown below

The result is as below:

Hope this helps

[Padycosmos]

Sorry, I am not aware of any such possibility.

[Idrissshatila]

Hello @Jalalk ,

Try formatting the column as text and see if it will be fixed.

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin

[Jalalk]

Column is already in text format.