question on slicer format

[erihsehc]

hi there,

how to create the slicer as this screenshot (which visual should be used), "total orders, total profits, total sales", see this design in the power bi sample. thanks

 Best regards,

ER

 

[Anonymous · Accepted solution]

Take the Slicer Visual type.  Find the column that relates to the data in your graph that will contain the 3 values you want to slicer by and drag that field into the slicers 'Field' box.

Right now this slicer will be a set of checkboxes, what we want to do is convert it from being a vertical to a horizontal slicer. You can achieve this by selecting the Paint Roller brush icon "Format" in the visualization pane.  Expand the 'General' settings and change Orientation to Horizontal.  Also toggle Lock aspect to On (its another item that can expand).