Custom Visual with Conditional Formatting

[Andrey]

Hello. I create a custom visual

tell me how I add Conditional Formatting

(https://community.powerbi.com/t5/Desktop/Custom-Visual-Using-Conditional-Formatting/td-p/323947

they say it is possible but it is not clear how. are there any examples?)

like this

My capabilities.json (i want add Conditional Formatting to totalPercentCritColor)

)

{
    "dataRoles": [
        {
            "displayName": "Value",
            "name": "Value",
            "kind": "Measure"
        }
    ],
    "dataViewMappings": [
        {
            "table": {
                "rows": {
                    "select": [
                        {
                            "for": {
                                "in": "Value"
                            }
                        }
                    ]
                }
            }
        }
    ],
    "objects": {
        "textOptions": {
            "displayName": "Text Options",
            "properties": {
                "phrase": {
                    "displayName": "Text",
                    "type": {
                        "text": true
                    }
                }
            }
        },
        "dataLabels": {
            "displayName": "Data Labels",
            "properties": {
                "dataLabelMeas": {
                    "displayName": "Data Suffix",
                    "type": {
                        "enumeration": [
                            {
                                "value": "руб.",
                                "displayName": "руб."
                            },
                            {
                                "value": "тыс.руб.",
                                "displayName": "тыс.руб."
                            },
                            {
                                "value": "млн.руб.",
                                "displayName": "млн.руб."
                            },
                            {
                                "value": "млрд.руб.",
                                "displayName": "млрд.руб."
                            },
                            {
                                "value": "%",
                                "displayName": "%"
                            }
                        ]
                    }
                },
                "dataLabelColor": {
                    "displayName": "Data Color",
                    "type": {
                        "fill": {
                            "solid": {
                                "color": true
                            }
                        }
                    }
                },
                "totalPercentCritColor": {
                    "displayName": "Sales Plan Crit Color ",
                    "description": "Цвет если план продаж не выполнен, см. Sales Plan Crit Value",
                    "type": {
                        "fill": {
                            "solid": {
                                "color": true
                            }
                        }
                    }
                },
                "totalPercentCritLevel": {
                    "displayName": "Sales Plan Crit Value",
                    "type": {
                        "numeric": true
                    }
                },
                "FormatText": {
                    "displayName": "FormatText",
                    "type": {
                        "formatting": {
                            "labelDisplayUnits": true
                        }
                    }
                }
            }
        }
    }
}

[Anonymous]

Conditional formatting is now supported in API 3.5 and above 

[rahul_aginicx]

Would you know if adding conditional formatting is in the roadmap and if yes, when would it be available in the custom visuals API?

[v-viig]

We'll consider this feature but we can not share any ETA.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

[Anonymous]

Hi,

Any update on this. Is this feature available for usage in Custom Visual ?

Thanks,

Kiran BV

[dm-p]

Hi @Anonymous - still not available, unfortunately. Would be great if it was, as I have a ton of uses for it 😞

[rahul_aginicx]

Thanks Ignat!

[v-viig · Accepted solution]

Conditional Formatting is not supported by Power BI Custom Visuals API so far.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

[Andrey]

thank you!