2023 Week 48 | Power BI: Ring Chart

Power BI Desktop

1. Obtain Deneb from AppSource
2. Create Measure to calculate percentage marriages by month for each State
3. Create rectangle mark layer, encode Month along Y-Axis, State along X-Axis, % Marriage by State by colour
4. Create your own colour scale
5. Create Measure to calculate sum of marriages
6. Create circle mark layer, encode Month along Y-Axis, State along X-Axis, sum of marriages by Size
7. Create text mark layer, encode Month along Y-Axis, State along X-Axis, sum of marriages by Size, colour the text marks conditionally based on gradient for best contrast.
8. Set the scales to resolve independently
9. TIP :

“resolve”: {

    “scale”: {

      “color”: “independent”,

      “size”: “independent”,

      “x”: “shared”,

      “y”: “shared”

    }