Slicer in Power BI Designer

[MiguelMartinez]

I am trying to use a slicer with a chart in Power BI designer but it won't let me configure the slicer to list values horizontally? Am I missing something? The slicer looks ugly without this

[mrvachon]

You might consider adding chart against the same data source and use that to slice the data. Since the charts are linked in the reports when you select a bar or pie slice ( for example) it should dynamically filter the other charts that are connected similar to how the slicer might behave.

[Olly]

But selecting a point in a chart HIGHLIGHTS that data, it doesn't FILTER it.

See https://support.powerbi.com/knowledgebase/articles/467092-about-filters-and-highlighting-in-power-bi...

[WillT · Accepted solution]

Two new features that should help you here Olly! Firstly, you can now set Slicers to 'horizontal' orientation (look in the formatting pane under the General section). And also you can use the 'Visual Interactions' feature to control whether charts cross-highlight or cross-filter other visuals! You can see details of that in our November update video: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-latest-update/#november-2015-updat... Hope that helps Will

[andre]

If you use a line chart, it will get filtered (unlike a bar chart) ,  but generally speaking you are right, having formatting options for a Slicer would definitely be much better.

[MiguelMartinez]

Currently, only slicers arranged in a vertical list are supported in the Power BI Preview. There is currently a suggestion on the Power BI support site to make them more flexible. You may consider up-voting and comment on it (https://support.powerbi.com/forums/265200-power-bi/suggestions/7028957-create-different-layouts-for-...), or you could create and vote on a new suggestion altogether. 

---

Regards,

Michael Amadi

Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful 🙂

Website: http://www.nimblelearn.com, Twitter: @nimblelearn