Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ysapiyev
Responsive Resident
Responsive Resident

Is there visual to highlight data

Hi everyone,

 

Is there any visual to highlight specific data using checkbox? Something like having multiple conditions and checkbox for this conditions, and when checkbox is selected, appropriate data is highlighted.

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@ysapiyev,

 

You may take a look at https://github.com/Microsoft/PowerBI-visuals/blob/e9886c7d77ab261b80bcd45eba97fa56005b8c1c/Capabilit....

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@ysapiyev,

 

You may take a look at https://github.com/Microsoft/PowerBI-visuals/blob/e9886c7d77ab261b80bcd45eba97fa56005b8c1c/Capabilit....

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-chuncz-msft,

 

Sorry, it works.

@v-chuncz-msft,

 

I looked at this article and some examples at capabilities of visuals on github, however, after I set supporthighlights true, in data view, there are no highlights array. Should I add some functions in my visual.ts? My capabilities code is presented below

 

{
  "dataRoles": [
    {
      "displayName": "Item name well test",
      "name": "category",
      "kind": "Grouping"
    },
    {
      "displayName": "Dates well test",
      "name": "date",
      "kind": "Grouping"
    },
    {
      "displayName": "Dates well read",
      "name": "date_wr",
      "kind": "Grouping"
    },
    {
      "displayName": "value1",
      "kind": "Measure",
      "name": "value1"
    },
    {
      "displayName": "value1 unit",
      "name": "value1_unit",
      "kind": "Measure"
    },

    {
      "displayName": "value2",
      "name": "value2",
      "kind": "Measure"
    },
    {
      "displayName": "value2 unit",
      "name": "value2_unit",
      "kind": "Measure"
    },
    {
      "displayName": "value3",
      "name": "value3",
      "kind": "Measure"
    },
    {
      "displayName": "value3 unit",
      "name": "value3_unit",
      "kind": "Measure"
    },
    {
      "displayName": "value4",
      "name": "value4",
      "kind": "Measure"
    },
    {
      "displayName": "value4 unit",
      "name": "value4_unit",
      "kind": "Measure"
    }
  ],
  "objects": {
    "myCustomObj": {
      "displayName": "Chart settings",
      "properties": {

        "threshold_color_1": {
          "displayName": "threshold_color_1",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "threshold_color_2": {
          "displayName": "threshold_color_2",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "threshold_color_3": {
          "displayName": "threshold_color_3",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "threshold_color_4": {
          "displayName": "threshold_color_4",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "fontSize": {
          "displayName": "Text Size",
          "type": {
            "formatting": {
              "fontSize": true
            }
          }
        },
        "fontSize_sec": {
          "displayName": "Text Size for sec",
          "type": {
            "formatting": {
              "fontSize": true
            }
          }
        },
        "fontFamily": {
          "displayName": "Font family",
          "type": {
            "enumeration": [
              {
                "value": "Arial",
                "displayName": "Arial"
              },
              {
                "value": "Arial Black",
                "displayName": "Arial Black"
              },
              {
                "value": "Arial Unicode MS",
                "displayName": "Arial Unicode MS"
              },
              {
                "value": "Bookman Old Style",
                "displayName": "Bookman Old Style"
              },
              {
                "value": "Calibri",
                "displayName": "Calibri"
              },
              {
                "value": "Cambria",
                "displayName": "Cambria"
              },
              {
                "value": "Candara",
                "displayName": "Candara"
              },
              {
                "value": "Castellar",
                "displayName": "Castellar"
              },
              {
                "value": "Comic Sans MS",
                "displayName": "Comic Sans MS"
              },
              {
                "value": "Consolas",
                "displayName": "Consolas"
              },
              {
                "value": "Constantia",
                "displayName": "Constantia"
              },
              {
                "value": "Corbel",
                "displayName": "Corbel"
              },
              {
                "value": "Courier New",
                "displayName": "Courier New"
              },
              {
                "value": "Georgia",
                "displayName": "Georgia"
              },
              {
                "value": "Impact",
                "displayName": "Impact"
              },
              {
                "value": "Lucida Calligraphy",
                "displayName": "Lucida Calligraphy"
              },
              {
                "value": "Lucida Sans Unicode",
                "displayName": "Lucida Sans Unicode"
              },
              {
                "value": "Segoe UI",
                "displayName": "Segoe UI"
              },
              {
                "value": "Segoe UI Light",
                "displayName": "Segoe UI Light"
              },
              {
                "value": "Symbol",
                "displayName": "Symbol"
              },
              {
                "value": "Tahoma",
                "displayName": "Tahoma"
              },
              {
                "value": "Times New Roman",
                "displayName": "Times New Roman"
              },
              {
                "value": "Trebuchet MS",
                "displayName": "Trebuchet MS"
              },
              {
                "value": "Verdana",
                "displayName": "Verdana"
              }
            ]
          }
        },
        "text_color": {
          "displayName": "text color",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "threshold_1": {
          "displayName": "value1 threshold",
          "type": {
            "numeric": true
          }
        },
        "threshold_3": {
          "displayName": "value3 threshold",
          "type": {
            "numeric": true
          }
        },
        "threshold_2": {
          "displayName": "value2 threshold",
          "type": {
            "numeric": true
          }
        },
        "threshold_4": {
          "displayName": "value4 threshold",
          "type": {
            "numeric": true
          }
        }

      }
    },
    "dataPoint": {
      "displayName": "Data colors",
      "properties": {
        "defaultColor": {
          "displayName": "Default color",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "showAllDataPoints": {
          "displayName": "Show all",
          "type": {
            "bool": true
          }
        },
        "fill": {
          "displayName": "Fill",
          "type": {
            "fill": {
              "solid": {
                "color": true
              }
            }
          }
        },
        "fillRule": {
          "displayName": "Color saturation",
          "type": {
            "fill": {}
          }
        },
        "fontSize": {
          "displayName": "Text Size",
          "type": {
            "formatting": {
              "fontSize": true
            }
          }
        }
      }
    }
  },
  "dataViewMappings": [
    {
      "categorical": {
        "categories": {
          "select": [

            {
              "for": {
                "in": "category"
              }
            },
            {
              "for": {
                "in": "date"
              }
            },
            {
              "for": {
                "in": "date_wr"
              }
            }
          ]

        },
        "values": {

          "group": {
            "by": "date",
            "select": [

              {
                "bind": {
                  "to": "value1"
                }
              },
              {
                "bind": {
                  "to": "value1_unit"
                }
              },
              {
                "bind": {
                  "to": "value2"
                }
              },
              {
                "bind": {
                  "to": "value2_unit"
                }
              },
              {
                "bind": {
                  "to": "value3"
                }
              },
              {
                "bind": {
                  "to": "value3_unit"
                }
              },
              {
                "bind": {
                  "to": "value4"
                }
              },
              {
                "bind": {
                  "to": "value4_unit"
                }
              }

            ]
          }
        }
      }
    }
  ],

  "supportsHighlight": true
 
}

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.