Forum Discussion
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
8 Replies
- v-viigCommunity Champion
Conditional Formatting is not supported by Power BI Custom Visuals API so far.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- AndreyRegular Visitor
thank you!
- rahul_aginicxNew Member
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-viigCommunity Champion
We'll consider this feature but we can not share any ETA.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- rahul_aginicxNew Member
Thanks Ignat!
- AnonymousNot applicable
Conditional formatting is now supported in API 3.5 and above