Powerviz
  • Introduction
  • Installation Guide
    • Install from Appsource
    • Import through file
    • Adding the Powerviz visuals as Organization visuals
  • Date Picker
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Calendar
      • Formatting
      • Date Picker Button
      • Default Selection
      • Date Selector
      • Presets
      • Selection Controls
      • Date Range
      • Invalid Dates
      • Weekends/Holidays
    • Themes
      • Default Theme
      • Custom Theme
  • Sunburst
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Chart Options
      • Data Colors
      • Fill Patterns
      • Arc Settings
      • Labels
      • Sorting
      • Ranking
      • Center Circle
      • Leaf Label Images
      • Conditional Formatting
      • Show Condition
      • Annotations
      • Grid View
    • FAQ
  • KPI
    • Introduction
    • Get Started
    • Format Pane
    • Edit Mode - Introduction
      • KPI Charts
        • Advanced Text
        • Bar Chart
        • Lollipop Chart
        • Line Chart
        • Area Chart
        • Combo Chart
        • Donut Chart
        • Pie Chart
        • Linear Gauge
        • Liquid Gauge
        • Radial Gauge
        • Bullet Chart
        • Waterfall Chart
        • Icon
        • Image
        • Shape
      • Templates
      • Small Multiples
      • Actions
      • Import/Export
  • Activity Gauge
    • Introduction
    • Get Started
    • Format Pane
    • Advance settings: Introduction
      • Gauge Options
      • Target
      • Data Colors
      • Fill Patterns
      • Labels
      • Ranking
      • Sorting
      • Center Circle
      • Mouse Over Text
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Annotations
  • Funnel Chart
    • Introduction
  • Horizon Chart
    • Introduction
  • Ridgeline Plot
    • Introduction
  • Rose/ Donut/Pie Chart
    • Introduction
  • Word Cloud
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Word Options
      • Data Colors
      • Shapes
      • Text Style
      • Direction
      • Ranking
      • Exclude
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Lasso and Reverse Lasso
  • Linear Gauge
    • Introduction
  • Filter
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings - Introduction
      • Filter Settings
      • Cell Style
      • Cell Colors
      • Title Bar
      • Column Headers
      • Image Styling
      • Default Selection
      • Conditional Formatting
      • Import/Export
      • Templates
  • Lollipop Chart
    • Introduction
  • Heatmap
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Shapes
      • Data Colors
      • Data Labels
      • Axis Settings
      • Grid Lines
      • Sorting
      • Plot Area
      • Reference Lines
      • Ranking
      • Totals
      • Small Multiples
      • Conditional Formatting
      • Show Condition
      • Grid view
      • Lasso and Reverse Lasso
  • Network Graph
    • Introduction
  • Sankey Chart
    • Introduction
Powered by GitBook
On this page
  1. Sunburst

FAQ

PreviousGrid ViewNextIntroduction

Last updated 1 year ago

Q: How can I change the number formatting to % format?

A: By default, Sunburst uses custom number formatting, which does not offer the percentage format. To use the % format, you can disable the number formatting option in the visualization pane.

To use Power BI formatting, disable the "number formatting" from the visualization pane.

Q: How can I change the number formatting to % format?

A: By default, Sunburst uses custom number formatting, which does not offer the percentage format. To use the % format, you can disable the number formatting option in the visualization pane.

INFO

To use Power BI formatting, disable the "number formatting" from the visualization pane.

A: By default, the Sunburst has the Zoom option enabled, which allows you to drill down into multiple layers. If you want to use highlighting instead, you can disable the zoom option in the advanced settings.

A: In the sunburst view, the value is calculated based on MAXX, MINX, and AVERAGEX, which evaluate an expression for each row of the table and return the value. In contrast, in the matrix view, the minimum value is calculated using quick aggregations based on MAX, MIN, and AVERAGE, which returns the value based on the entire column.

Sunburst Visual only has access to limited data, unlike Power BI visuals, which cannot access entire data and give the same output.

A: In Sunburst, the child node values are added to determine the next level, while in matrix view, the average is calculated based on each row's values for the layer.

How Matrix calculates:

Average Sale = AVERAGE(Orders[Sales])
or
Average Sale = SUM(Orders[Sale])/COUNTROWS(Order) = 260. 

How Sunburst calculates:

Average Sale for Parent level [Q1] = Sum of Child layer values. [Jan+Feb+Mar]

This is done to avoid discrepancies where the total of rows is not equal to 100% in the matrix view. The sunburst adding-up method ensures that the total is always 100%.

A: In the Sunburst center circle, "auto-fit content" is enabled to ensure the best fit of all the layers. If the setting exceeds the center circle limit, it compresses the size of the layers. To see the actual settings and aspect ratio, disable this option.

NOTE

Keep in mind that if the input value is higher than the center circle space, the layers will overlap.

A: If "auto-fit content" is disabled, and the layer size is higher than the center circle area, it will overlap. Enable "auto-fit size" for the best fit.

A: By default, Sunburst ranking shows the top 5 with the remaining values as "others."

A: Like any other circular form visual, in the case of data with a mix of negative and positive values, Sunburst will only show positive values.

A: Hide is used to temporarily remove all the comments from the screen. They will reappear after refreshing the page. To permanently delete a comment, use the delete option instead.

A: In the case of "Others," it clubs all the values apart from the top/bottom N. But from the second layer onward, "Others" clubs value based on 2-level information.

In this example, the 3 Technologies represent values from Saturday, Tuesday and Wednesday. Hence clubbing makes it hard to verify.

Q: How can I enable cross-highlight in the Sunburst?

Q: Why are the minimum values in the matrix and sunburst views different?

Q: Why are Powerviz Sunburst and Power BI Matrix outputs different when using AVERAGE?

Q: Why is the aspect ratio in the center circle not working?

Q: Why are the center circle values overlapping the visual?

Q: Why is there an "others" name node on the screen?

Q: Why is Sunburst hiding all the negative values from the data?

Q: How does the Hide option work in annotations?

Q: How to use the Show condition?

A: Refer to this page to learn more about the .

Q: Why are images not working in Sunburst?

A: Due to the latest in Power BI, custom visuals cannot use private URLs. To render images, use base64 encoded URLs.

Q: Why are the categories repeating within "Others"?

​
​
​
​
​
​
​
​
​
Show condition
​
privileges update
​
​