Forum Discussion
Slicer values selection Vertical or Horizontal option missing in Power BI Desktop July verison
- 9 years ago
- 8 years ago
You definitely resolved the issue for me. Thanks!
I am on the latest release of Power BI desktop, and I only have "Vertical List", "Tile", and "Dropdown" as style options. "Horizontal List" is not there.
ok, so this is a bit ugly but this might be useful as a quick fix or the right way 🤔
You can actually resize the slicer box and it will select various format sizes as necessary as long as the Responsive Field in the Advanced Options for the Slicer ir set to On
If you select add slicer from vizualisations and add your field, the result seems to be a default vertical list option with quite a wide box.
If you then drag the left hand border slicer box arrow nearer to the right border Power BI will narrow the slicer box and it will automatically resize as you go.
I have found this works whether the Slicer Settings - Options - Style [is] Tile or Vertical List.
As Power BI develops it gets much simpler in some ways and more testing in others - the change of icon in Vizualisations from the old paint roller to the new columnar paint brush - is a significant change - and so solutions using the old paint roller need tweaking
- datawiz232 years agoFrequent Visitor
While looking for images to show this process, I then came across this 😂
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-slicer-filter-responsive