Looking for a visual or hint how to make one like this

[Anonymous]

Hi,

Using sample JSON data I need to build a visual most like screen below. Have you seen something like this or could you advice how can i make it?

Green <=9, Yellow >9 and <=10,
Orange >10 and <=11, Red >11 and <=12, Black >12

The JSON file is like this if it is needed to help me:

{
  "Statistics": {
    "Segments": {
      "Readability_Indexes": {
        "row": [
          {
            "@name": "Gunning-Fog Index",
            "@value": "11.85",
            "@percent": "-1",
            "@hvalue": "12.18",
            "@hpercent": "-1"
          },
          {
            "@name": "Flesch Reading Ease score",
            "@value": "51.98",
            "@percent": "-1",
            "@hvalue": "52.32",
            "@hpercent": "-1"
          },
          {
            "@name": "Flesch-Kincaid Grade Level score",
            "@value": "8.14",
            "@percent": "-1",
            "@hvalue": "8.88",
            "@hpercent": "-1"
          },
          {
            "@name": "Automated Readability Index (ARI)",
            "@value": "8.59",
            "@percent": "-1",
            "@hvalue": "16.58",
            "@hpercent": "-1"
          },
          {
            "@name": "SMOG Index",
            "@value": "10.8",
            "@percent": "-1",
            "@hvalue": "11.58",
            "@hpercent": "-1"
          },
          {
            "@name": "Average Readability Index",
            "@value": "11.15",
            "@percent": "-1",
            "@hvalue": "14.724",
            "@hpercent": "-1"
          }
        ]
      }
    }
  }
}

[Icey]

Hi @Anonymous ,

Can you accept changing the icon? Maybe you can choose something similar like this. You can change the color of each bar and use it like what mentioned here: Power BI RAG Icons Custom Conditional Formatting (mssqltips.com).

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

How close does it have to be to the example you provided?

You can do conditional formatting without needing extra visuals.

[Anonymous]

As close as possible.

I did the formatting as you did above. The problem is to create the visual. I used matrix and got close enough but it is not the same. Plus i can not get a second column with data live above in rows as in matrix it creates this [+] and it adds another row ;/