Power BI: using a TreeMap instead slicer

Step 1: Insert a Treemap

  • Open Power BI Desktop and go to the Report view.
  • From the Visualizations pane, select the Treemap visualization type and insert it onto the canvas.
  • Position the Treemap visualization above the chart.

Step 2: Add Fields for Slicing

  • In the Fields pane, locate the desired field for slicing, such as "Product Category."
  • Drag and drop the "Product Category" field onto the Treemap visualization to slice the data by this field.

Step 3: Add Values to the Treemap

  • Since the Treemap requires a value field, drag and drop a numerical field, like "Total Sales," onto the "Values" area of the Treemap visualization.
  • To ensure uniform square sizes in the Treemap, create a measure that returns a constant value.
  • Rename the measure to "Slicer Size" and set its value to 1.
  • Drag and drop the "Slicer Size" measure onto the "Values" area of the Treemap visualization.

Step 4: Resize the Treemap Slicer

  • Adjust the size of the Treemap visualization so that the rectangles appear adjacent to each other.
  • If desired, turn off the title of the Treemap visualization by going to the "Format" pane and disabling the title option.

Step 5: Disable Hover Popup for Slicer Items

  • In the "Format" pane, find the option to turn off the pop-up that appears when hovering over the slicer items.
  • Disable the hover pop-up to improve the visual appearance.

Step 6: Adjust Interaction with Other Visuals (optional)

  • Decide how other visuals on the report page should interact with the Treemap slicer.
  • Select each visual, go to the "Format" pane, and navigate to "Edit Interactions."
  • Set the interaction to filter the items in the Treemap slicer based on the selection made in other visuals. Alternatively, set the interaction to none to prevent any interaction between the visuals.

Step 7: Explore Using a Field with More Items on the Slicer

  • Replace the "Product Category" field in the chart with a field containing more items, such as "Products."
  • Add another slicer for the "Product Category" field, similar to the previous Treemap slicer.
  • Modify the Treemap slicer to use the "Product Name" field instead of "Product Category."
  • Adjust the layout and filters as needed to improve the display and selection experience.


Комментарии

Популярные сообщения из этого блога

Today's activity report #17