Forum Discussion

RubenMerino's avatar
RubenMerino
Frequent Visitor
2 years ago

Dynamic background colour by multiple measure

I have a tooltip page with table visual that have 2 columns of a table named QC_Inductors:

 

  1. Inductors: it's string column with name of indicator
  2. Descripcció: It's string column with description about indicator

The tooltips work with on hover on exclamation symbol

--------------------------------------------------------------------

 

The background colour takes the integer value of column "Color" of table QC_Inductors_Actual and it's a conditional value between the comparation columns. In summary, "Color" tells us if value of "Resultat" column its under or over value in column "Tall01", "Tall02", "Tall03". QC_Inductors and QC_Inductors_Actual have a relationship when them. 

 

  • Relationship

 

 

  • Color column logic:

 

 

The problem is that value of "Resultat" column it's values of measures in specific moment of time. Concretely, it's the last month with data. So, it's fixed value that only change when increase de data.

 

 

 

Problem

 

 

When us a filter date, the measure that it's in tooltip keep the colour that there are in table. But in this case, with more than 20%, the colour should be yellow.

So, the point it's if there some way to background colour change withe de value of measure under date filter condition. But, it's important to know the different exclamation symbols on different card have different measures, as show in the image.

 

 

 

 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, RubenMerino 

    Can you provide a sample data or PBIX file that can get measure or does not contain sensitive information?

    So that I can help you better.

     

    Best Regards

    Yongkang Hua