Forum Discussion

fdanielsouza's avatar
fdanielsouza
Helper I
5 years ago
Solved

Highlight bug with boolean measures

Hi, I noticed that the highlight array have the same values of the data array, but with nulls where points aren't selected. When the measure returns a boolean value, however, the array gives falses i...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI fdanielsouza,

    Have you tried to use a column with other type values? Bool type is different than common visuals and they may affect/conflict with the visual render and analysis. (AFAIK, sometimes they can be defined to control to enable some features)

    In addition, you can also contact to power bi team and attach your sample pbix file to help them reproduce and confirm this scenario.
    Regards,

    Xiaoxin Sheng

fdanielsouza's avatar
fdanielsouza
Helper I
5 years ago

Hi Anonymous , it's a categorical visual with one category field and a values field that accepts several measures. For highlighting I'm using the options.dataViews[0].categorical.values[0].highlights array to determine if a value is highlighted or not, but the behaviour changes when I use a measure like SELECTEDVALUE([boolean_column]). Instead of give nulls, it give falses. So, if the highlighted value is a false, then the entire array will be of falses, which hinders the highlighting.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI fdanielsouza,

    I think this may relate to selectedvalue function.

    SELECTEDVALUE function - DAX | Microsoft Docs
    AFAIK, selectedvalue not suitable for multiple selections. if you do not add 'alternate result' to selectedvalue function, it will invoke 'blank' function to handle this exception result.(mutiple item seleciton)

    BLANK function (DAX) - DAX | Microsoft Docs

    Handling BLANK in DAX - SQLBI
    If you add this optional parameter in selectedvalue function, did these parts still get the wrong results?

    Regards,

    Xiaoxin Sheng

    • fdanielsouza's avatar
      fdanielsouza
      Helper I
      5 years ago

      I don't think it's related to the function per se, because if I use an implicit measure in a boolean column (like "first this_boolean_column") the problem stands

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI fdanielsouza,

        Have you tried to use a column with other type values? Bool type is different than common visuals and they may affect/conflict with the visual render and analysis. (AFAIK, sometimes they can be defined to control to enable some features)

        In addition, you can also contact to power bi team and attach your sample pbix file to help them reproduce and confirm this scenario.
        Regards,

        Xiaoxin Sheng