Forum Discussion

Andrey's avatar
Andrey
Regular Visitor
8 years ago
Solved

Custom Visual with Conditional Formatting

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

 

 

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

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

8 Replies

  • v-viig's avatar
    v-viig
    Community Champion

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

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Conditional formatting is now supported in API 3.5 and above