topic Custom Visual with Conditional Formatting in Developer

Custom Visual with Conditional Formatting

Andrey — Sun, 04 Mar 2018 16:12:18 GMT

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
                        }
                    }
                }
            }
        }
    }
}

Re: Custom Visual with Conditional Formatting

v-viig — Mon, 05 Mar 2018 08:09:04 GMT

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Custom Visual with Conditional Formatting

Andrey — Tue, 06 Mar 2018 09:12:39 GMT

thank you!

Re: Custom Visual with Conditional Formatting

rahul_aginicx — Thu, 17 May 2018 02:04:38 GMT

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

Re: Custom Visual with Conditional Formatting

v-viig — Thu, 17 May 2018 09:10:12 GMT

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Custom Visual with Conditional Formatting

rahul_aginicx — Fri, 18 May 2018 00:32:24 GMT

Thanks Ignat!

Re: Custom Visual with Conditional Formatting

Anonymous — Thu, 25 Jun 2020 03:01:03 GMT

Hi,

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

Thanks,

Kiran BV

Re: Custom Visual with Conditional Formatting

dm-p — Thu, 25 Jun 2020 22:57:55 GMT

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

Re: Custom Visual with Conditional Formatting

Anonymous — Sat, 12 Jun 2021 16:07:52 GMT

Conditional formatting is now supported in API 3.5 and above