Forum Discussion

erihsehc's avatar
erihsehc
Helper III
8 years ago
Solved

question on slicer format

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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).

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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).