Custom Report, displaying general quantiles in bar chart style instead of boxplot

This can be done with the Deneb visual. I did a quick POC but much more could be done to pretty it up. You should be able to take the code below, put it in the visual and edit the field mapping (to switch it to your data).

Declarative Visualization in Power BI | Deneb

{
  "data": {"name": "dataset"},
  "transform": [
    {
      "aggregate": [
        {
          "op": "min",
          "field": "Total Sales",
          "as": "Min"
        },
        {
          "op": "max",
          "field": "Total Sales",
          "as": "Max"
        },
        {
          "op": "median",
          "field": "Total Sales",
          "as": "Median"
        },
        {
          "op": "q1",
          "field": "Total Sales",
          "as": "Q1"
        },
        {
          "op": "q3",
          "field": "Total Sales",
          "as": "Q3"
        }
      ],
      "groupby": ["Subcategory"]
    }
  ],
  "layer": [
    {
      "mark": {
        "type": "bar",
        "color": "red"
      },
      "encoding": {
        "y": {
          "field": "Min",
          "type": "quantitative"
        },
        "y2": {"field": "Q1"}
      }
    },
    {
      "mark": {
        "type": "bar",
        "color": "blue"
      },
      "encoding": {
        "y": {
          "field": "Q1",
          "type": "quantitative"
        },
        "y2": {"field": "Median"}
      }
    },
    {
      "mark": {
        "type": "bar",
        "color": "green"
      },
      "encoding": {
        "y": {
          "field": "Median",
          "type": "quantitative"
        },
        "y2": {"field": "Q3"}
      }
    },
    {
      "mark": {
        "type": "bar",
        "color": "yellow"
      },
      "encoding": {
        "y": {
          "field": "Q3",
          "type": "quantitative"
        },
        "y2": {"field": "Max"}
      }
    }
  ],
  "encoding": {
    "x": {"field": "Subcategory"}
  }
}

Pat