Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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"
}
]
}
}
}
}
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.
How close does it have to be to the example you provided?
You can do conditional formatting without needing extra visuals.
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 ;/
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
91 | |
84 | |
69 |