Make a clustered bar chart with conditional formatted leged in Deneb.

[jaryszek]

Hello,

I am trying to use Deneb as my chart in ordet to replace clustered bar chart with legend colors. 

For bar chart without legend I am using Dax Measure like this:

Color by Rank = 
VAR r = [Rank (Current Axis)]
RETURN
SWITCH (
    TRUE(),
    ISBLANK ( r ) || r > 5, "#B3B3B3",
    r = 1, "#E81123",
    r = 2, "#107C10",
    r = 3, "#0078D4",
    r = 4, "#FFB900",
    r = 5, "#8E8CD8"
)

Power bi limitation is that you can not use measure and condtional format it:

How to make this in Deneb? 
Anyone did this? 

My bar chart is here:

https://drive.google.com/file/d/14lpEWK-MQ6JMU5_15WVh8Gv22AiGvdpR/view?usp=sharing

Will be extremely grateful for help,
Best,
Jacek

[v-ssriganesh]

Hello @jaryszek,
Thank you for posting your query in the Microsoft Fabric Community Forum. Here’s how you can achieve this in Deneb:

Prepare your data with a “Rank” field that categorizes each bar (e.g: 1, 2, 3, 4, 5) and In your Deneb visual’s Vega-Lite JSON, set up a color scale that directly relates each rank value to a specific hex color. The legend will reflect these specific assignments.

Example json code:

"color": {
  "field": "Rank",
  "type": "nominal",
  "scale": {
    "domain": [1, 2, 3, 4, 5, "Others"],
    "range": ["#E81123", "#107C10", "#0078D4", "#FFB900", "#8E8CD8", "#B3B3B3"]
  },
  "legend": {
    "title": "Rank",
    "labelExpr": "datum.value == 'Others' ? 'Others' : 'Rank ' + datum.value"
  }
}

Please give it a try and let me know if you encounter any issues.

Best regards,
Ganesh Singamshetty.

[jaryszek]

Thank you very much, 

i tried with :

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "data": {"name": "dataset"},
  "transform": [
    {
      "calculate": "(datum['Rank (Current Axis)'] == null || datum['Rank (Current Axis)'] > 5) ? 'Others' : toString(datum['Rank (Current Axis)'])",
      "as": "RankBucket"
    }
  ],
  "mark": {"type": "bar", "tooltip": true},
  "encoding": {
    "x": {
      "field": "Date",
      "type": "temporal",
      "timeUnit": "yearmonthdate",
      "axis": {"labelAngle": -40, "title": null}
    },
    "xOffset": {
      "field": "MeterCategory",
      "type": "nominal",
      "title": null
    },
    "y": {
      "field": "Sum of CostInBillingCurrency",
      "type": "quantitative",
      "aggregate": "sum",
      "axis": {"title": null}
    },
    "color": {
      "field": "RankBucket",
      "type": "nominal",
      "scale": {
        "domain": ["1","2","3","4","5","Others"],
        "range": ["#E81123","#107C10","#0078D4","#FFB900","#8E8CD8","#B3B3B3"]
      },
      "legend": {
        "title": "Rank",
        "labelExpr": "datum.value === 'Others' ? 'Others' : 'Rank ' + datum.value",
        "orient": "right"
      }
    },
    "order": {"field": "MeterCategory"}
  },
  "config": {
    "view": {"stroke": null},
    "axisY": {"grid": true},
    "bar": {"size": 10}
  }
}

but have no idea how to make this working. 

Can i use dynamic color range from power bi measure instead of this ?:

"color": {
  "field": "Rank",
  "type": "nominal",
  "scale": {
    "domain": [1, 2, 3, 4, 5, "Others"],
    "range": ["#E81123", "#107C10", "#0078D4", "#FFB900", "#8E8CD8", "#B3B3B3"]
  },

Best wishes,
Jacek

[v-ssriganesh]

Hello @jaryszek,
No, Deneb cannot use a Power BI measure (like [Rank (Current Axis)]) for the color range. Measures are not available in the Deneb dataset only table columns are.

Use Vega-Lite transforms (like aggregate + window) to calculate rank and assign colors dynamically no DAX needed.

Thank you,
Ganesh Singamshetty.